cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a new column with percentiles?

leo82
8 - Cloud Apps
8 - Cloud Apps

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? 

 

percentiles.jpg

1 REPLY 1

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @leo82 ,
You can create a conditional column with percentile function with group by field.

Angelina_QBeeQ_1-1684827688016.png

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.

Angelina_QBeeQ_3-1684827989272.png

And then filter this value by 1.

Angelina_QBeeQ_4-1684828035650.png

Final table: 

Angelina_QBeeQ_6-1684828116284.png

Always here to help,
Angelina from QBeeQ
angelina.bulgakova@qbeeq.io
QBeeQ  - Gold Implementation and Development Partner