Skip to main content
Stuart
Stuart
Helper ⭐️⭐️
Jul 19, 2022 11:03 AM UTC
Question

PX: Query Builder: Aggregate/Rollup Global Context data

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!

1 reply

sgage
Gainsight Employee ⭐️
sgage
Gainsight Employee ⭐️
Jul 19, 2022 7:11 PM UTC

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!

Translate
Stephanie Gage | Solutions Architect, PX
    Terms & ConditionsAccessibility statement