Hey Folks,

Similar to the use case set out in the support docs here PX is collecting data on which project a user is working on at any time.

I’m looking to use query builder to show

• # projects viewed/used by unique
  • User
  • Account

The output i’m looking for is a number per user/account; for example

• User X has viewed/used Y number of Projects in Z timeframe
• The Users in Account A have collectively viewed/used B number of Projects in C timeframe.

I’m unable to get query builder to group the results in the desired way.  Any thoughts on if this is possible, and if so, how I’d need to configure QB?

Thanks!