Forum Discussion
How to get around average a average
i am trying to calcurlate average handled time
i have creaated a custom column which divides total handled time by handled calls to get my average call time which then shows per row which is ok for some of my data but the problem i have is i have to display the data which groups some of the rows. for example to report on DINO calls they have 4 lines which feed into this, this means when i display it in a visulisation it is averaging the average as it is grouping together those 4 lines to show the aveage,
has anyone come up against this before and has some advise/tips?
Hello roryv2002,
1. Create a measure to calculate the total handled time for each group
TotalHandledTime_Grouped = SUM('YourTable'[TotalHandledTime])2. Create a measure to calculate the total handled calls
HandledCalls_Grouped = SUM('YourTable'[HandledCalls])3. Create a measure that divides the total
AverageCallTime = DIVIDE([TotalHandledTime_Grouped], [HandledCalls_Grouped])
1 Reply
Hello roryv2002,
1. Create a measure to calculate the total handled time for each group
TotalHandledTime_Grouped = SUM('YourTable'[TotalHandledTime])2. Create a measure to calculate the total handled calls
HandledCalls_Grouped = SUM('YourTable'[HandledCalls])3. Create a measure that divides the total
AverageCallTime = DIVIDE([TotalHandledTime_Grouped], [HandledCalls_Grouped])