avg Top Five and average bottom 5 from a complexe mesure

[brunobertels]

Hi Dear All, 

Let's say i have a complexe mesure like below to calculate average call lenght : 

round((sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))
)
+
(

sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))),'00:00:01')

I would like to have the average top 5 call length average and bottom 5 call lenght average  

I'am able to rank the mesure "DMT" in a strait table but i don't know how i can have the average DMT from top 5 and bottom 5 in a KPI for exemple 

So help may be appreciate 

Thanks in advance 

Bruno

[Kushal_Chawda]

may be below

For Top 5 -

=round(avg(aggr(if(rank((sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))
)
+
(
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))),0,4)<=5,
(sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))
)
+
(
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE)))),NOM,DATE)),'00:00:01')

For Bottom 5-
=round(avg(aggr(if(rank(-((sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))
)
+
(
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE)))),0,4)<=5,
(sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Appel entrant'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE))
)
+
(
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}TEMPS),SITE,FILE,LOG,NOM,DATE))
/
sum(aggr(sum({$<INDICATEURS={'Post-travail'}>}[PROD.VOL.PROD]),SITE,FILE,LOG,NOM,DATE)))),NOM,DATE)),'00:00:01')