Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have two dimensions (Seisoen and Maand)
I want to calculate the median of the top five values
I used the following expression but it doesn't seem to give the overall median for the top 5 values
if(
num(left(rank(aggr(sum(if([Seisoen Kort]>=vSeisoenBrake,[MM Daaglikse Syfers],
if([Seisoen Kort]<vSeisoenBrake,[MM Maand Syfers]))),Seisoen,Maand)),1),'0') <=5
and
(mid(rank(aggr(sum(if([Seisoen Kort]>=vSeisoenBrake,[MM Daaglikse Syfers],
if([Seisoen Kort]<vSeisoenBrake,[MM Maand Syfers]))),Seisoen,Maand)),2,1)='-'
or
trim(mid(rank(aggr(sum(if([Seisoen Kort]>=vSeisoenBrake,[MM Daaglikse Syfers],
if([Seisoen Kort]<vSeisoenBrake,[MM Maand Syfers]))),Seisoen,Maand)),2,1))=''),
median(aggr(sum(if([Seisoen Kort]>=vSeisoenBrake,[MM Daaglikse Syfers],
if([Seisoen Kort]<vSeisoenBrake,[MM Maand Syfers]))),Seisoen,Maand))
)
Any help would be greatly appreciated
Regards
Anri
Hi Anriretief,
I created a small sample, and use median() function to calculate the result, hope that's what you want.
You can change the column name in your dashboard.
Aiolos
Hi Anriretief,
I created a small sample, and use median() function to calculate the result, hope that's what you want.
You can change the column name in your dashboard.
Aiolos