This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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
