Hi good afternoon!
I need to create a calculated field where the result is a percentage rank of the number of transactions by users: Example:
10% of users made 20 transactions;
20% of users have made 300 transactions;
30% of users have made 1000 transactions;
40% of users have made 5000 transactions.
Hello @jcolucci !
To clarify, do you want a parameter control filter that a user can select one of the % and affect a calculated field? For example a user selects '10%" from a drop down, and then a calculated field shows that percentage of users transactions?
1 Like
Hi Duncan, good morning!
No Duncan… what I need is to create a graph where on the Y axis there is a percentage range of every 10 percent and on the X axis the number of users who are in these percentage ranges.
1 Like
Hi Duncan, good afternoon!
Any progress with the issue involved?
Do you have a solution so I can display the graph?
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
Hi @jcolucci,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this case.
Thank you!
Hi @jcolucci,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
Thank you!