duncan
5
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