topic Percentile Calculation in App Development

Percentile Calculation

deepanshuSh — Mon, 27 Mar 2023 12:38:08 GMT

Hi,

I want to calculate the percentile for each ID, based on the sum(value). Basically, I want to take the max(sum(value) ) as base considering it as 100% and calculate where the remaining IDs belong to. I want to understand which percentile does each ID belongs to when compared to whole data.

Re: Percentile Calculation

Or — Mon, 27 Mar 2023 12:58:28 GMT

Have a look at the Fractile() function.

You may need to wrap it in an aggr() function to get it working on a per-ID basis as well - I'm not sure because I wasn't quite able to understand what you were trying to do based on your post.

Re: Percentile Calculation

MarcoWedel — Mon, 27 Mar 2023 21:16:23 GMT

From your description I understand a percentage rather than a percentile, are you maybe looking for an expression like this:

Num(Sum(Value)/Max(TOTAL Aggr(Sum(Value),ID)),'0%')

Re: Percentile Calculation

deepanshuSh — Tue, 28 Mar 2023 04:27:31 GMT

Thanku @MarcoWedel and @Or for your inputs. I am trying to use the fractile function already, but was unable to get the required results. I wanted to get a summation of the value column and then use that for getting the percentile using the fractile function, I tried the alternative approach using Marco's Suggestion. It kind of solved the problem.