Dear Team,
Please find the attached print screen for one of the visualization.
This talks about month on month total call time, total acd (talk time), acw and hold time. Total call time is the result for other metrics.
I need a % calculation for each month. i.e. ACD % of the month, ACW% and hold% but i am not able to achieve so. The % of column does not give me the desired result and shows all as 100%.
Kindly suggest.
3 answers
I believe if you create a calculation like:
SUM(total acd time)/sum(total calltime) you will get the percentage you are looking for. Repeat for the other two measures.
