How to create a new column with percentiles?
In Sisense, I'm looking for a way to create a new column in a table, with percentile values of a different column. I am open to design suggestions/approach. What the best way to accomplish this. Su...
Forum Discussion
Hi leo82 ,
You can create a conditional column with percentile function with group by field.
In the formula, you need to compare the value with the percentile and write 1 or 0. If the value is greater than the percentile then 1, otherwise 0.
And then filter this value by 1.
Final table:
Always here to help,
Angelina from QBeeQ
angelina.bulgakova@qbeeq.io
QBeeQ - Gold Implementation and Development Partner
