How to achieve Percentile or custom aggregation.
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.
2 answers
any alternate solution for above query would be much appreciated.
Hi,
It seems you can write such formula in WebDataRocks.
The formula will look like this one: sum(“value”) / max(“value”) * 100.
Regards,
Hugo