2021-02-26

Calculate average across all the branches for that day

I am currently struggling on how to calculate average across all the branches.

Like below you can see, call queue name is the unique name that has a call count for each day, multiple times a day.

I want to calculate the average call count across all the call queue names for each day to compare individual call name across the average of all the call queue names.

I am struggling for quite sometime and I was able to use averagex,

Per_day_count = AVERAGEX(VALUES(fAgentTimelineAnalytics[Call Queue Name]), 
CALCULATE(COUNT(fAgentTimelineAnalytics[Call Count])))  

Can someone please point me in the right direction.

enter image description here



from Recent Questions - Stack Overflow https://ift.tt/2MuPT8O
https://ift.tt/3dNQqxG

No comments:

Post a Comment