How to achieve Percentile or custom aggregation.

Answered

Want to find maximum in whole column and based on that need to calculate percentile.
Note: I can find the maximum value from API and pass it to Pivot table, but it won’t work when I filter/aggregate data. 
Please find attached to check percentile.
 
 

Attachments:
Capture.JPG

2 answers

any alternate solution for above query would be much appreciated.

Hugo Martinez December 1, 2020

Hi, 
It seems you can write such formula in WebDataRocks.
The formula will look like this one: sum(“value”) / max(“value”) * 100.
Regards,
Hugo