Forum Discussion

leo82's avatar
leo82
Cloud Apps
05-22-2023

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.

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? 

 

 

Code-first Analytics
Data Models

1 Reply

Replies have been turned off for this discussion
  • Angelina_QBeeQ's avatar
    Angelina_QBeeQ
    ETL
    05-23-2023

    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