topic Re: Number of Occurences Above Avg in App Development

Number of Occurences Above Avg

Pericator — Wed, 23 Oct 2019 10:26:14 GMT

Hello,

I want to calculate the number of occurencies above or below Avg. See Example:

User	Percentage Value
1	5%
2	10%
3	15%
4	20%
5	25%
6	30%
7	35%
8	40%
9	45%
10	50%

I calculate the Average Values of the Percentages easily, but how can I count the number of Users, which are above/below the Average Percentage Value.

Note: Please suggest how can I handle it in the expression directly not in the load script.

Thanks in Advance

Re: Number of Occurences Above Avg

sunny_talwar — Wed, 23 Oct 2019 11:25:31 GMT

What is your expression for the Percentage value?

Re: Number of Occurences Above Avg

Pericator — Wed, 23 Oct 2019 11:35:36 GMT

They are pre calculated and are fixed in the qvd. So its just plane numbers.

Re: Number of Occurences Above Avg

sunny_talwar — Wed, 23 Oct 2019 11:40:01 GMT

So try this may be for Above

Count({<User = {"=[Percentage Value] > Avg(TOTAL [Percentage Value])"}>} DISTINCT User)

for Below

Count({<User = {"=[Percentage Value] < Avg(TOTAL [Percentage Value])"}>} DISTINCT User)

for Equal

Count({<User = {"=[Percentage Value] = Avg(TOTAL [Percentage Value])"}>} DISTINCT User)