Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')