Forum Discussion
Solved
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 ...
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])
Sahir_Maharaj
Super User
Super UserHello 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])