Forum Discussion
How to create equally sized quintiles, sorted by second variable?
Hi aukev
Could you show me with a screenshot how it looks like when you add “Quartile (Frequencies) 2” in the table visual?
“quintiles with equal numbers of customers”
Does this mean the quintiles show the same value for the same numbers of customer id?
“ranked by frequency”, could you show me an example of your expected result?
Best regards
Maggie
Thank you for your help. What I`m seeing now is this:
The Q1 is missing but more importantly the quartiles are segmented based on the sum of the frequency.
What I`m looking for is as shown below. Where the quartiles are segmented by the number of customer ids within them.
v-juanli-msft or anyone else, still looking for a solution to this. Any help would be awesome :)
Hi aukev
The Frequency column is different from the second screenshot and the first screenshot.
Does this column exsit in the table or Is it created by you?
How does this column generate?
Best Regards
Maggie
- They are the same, this is just a mistype in my example. The frequency column is a calculated column.