Skip to main content

Hey Folks,

 

We’re passing a project reference number from our application to global context.  I’m interested in using query builder to create a rollup to show Total number of projects where any action has been taken in the last xx days.  I’m able to produce reporting to show # users, # accounts per project, but so far I’ve not been able to configure QB to provide a rollup of distinct project reference numbers.

 

Anyone have any ideas on how to accomplish this, if it can be accomplished in QB or in AE in CS?

 

Thanks!

Hi @Stuart ,

You can use Query Builder with the following configurations to achieve this:

Events

  • EVENT 1:
    Feature: (must be a specific feature(s)
  • WHERE
    A. globalContextName] is not empty
  • GROUP BY:
    globalContextName]


Audience

  • WHERE
    A: Last seen (enter desired range)

Hope this helps!

Reply


Terms & ConditionsCookie settings