Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a straight table where i am grouping on a employee level, what i want to do now is measure an average on the employee level against the average on a team leader level (the empoyee's team leader)
So if Agent X is a member of team Y, i want Agent X's Average measured against Team Y's Average (Agent X is a member of team Y)
i want this calculation to happen regardless of whether anything has been selected or not
thanks
Hi Stephen,
sounds like you want to use average aggr() over the higher level dimension, would be helpful if you can upload an example application to work with
Joe
Hi Joe,
Unfortunately can't upload, but i came right with some trial and error:
(
sum(Hold_time)/sum(Hold_Time_Occ)
)
/
(
aggr(nodistinct sum(Hold_time), TLead )
/
aggr(nodistinct sum(Hold_Time_Occ), TLead )
)
Thanks