Create a parameter (Rank

Hey @jcolucci !

I’m sorry about the late reply! Could you share how your data is structured? That would help me understand how a calculated field needs to be created.

My initial thought is you can probably use percentile:

And then take a distinct count of the users per group, so something like this:
distinctCountOver({user}, [{percentileCalc}], PRE_AGG)

It might be easier to troubleshoot with an arena if you could add sample data:

1 Like