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.
Such that: 1. Have a filter created on percentile values of the column X. 2. Filter out outliers when plotting or graphing the data. (e.g. I am interested in 0.99 percentile data only), If I have a percentile column I can easily filter out top 0.1 values.
Anyone came across any examples of how best to implement this in Sisense (cube level?) or UI dashboard level?
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
[email protected]
QBeeQ - Gold Implementation and Development Partner
