Forum Discussion
Division by categories
Hello guys, I would like to do the following division: Avg Call length equal to ("Engage Time" plus "Wrap Time") divide "Accepted" Yet my calculated result seems wrong as the table below
Anonymous ,
Call Length = DIVIDE([Total Engage Time] + [Total Wrap Time] , SUM(Table9[Accepted]))Total Engage Time = SUM(Table9[Engage Time])Total Wrap Time = SUM(Table9[Wrap Time])Regards,HN
amitchandak
Sample Data:
| Agent Name | Queue | Accepted | Engage Time | Wrap Time |
| a | UNKNOWN | 1 | 985 | 0 |
| a | VQ_Supervisor_Hotline | 1 | 66 | 10 |
| a | UNKNOWN | 2 | 273 | 5 |
| a | VQ_Supervisor_Hotline | 1 | 22 | 36 |
| a | UNKNOWN | 4 | 2822 | 0 |
| a | VQ_ElderlyAndDisable | 1 | 42 | 13 |
| a | VQ_Supervisor_Hotline | 1 | 14 | 6 |
| a | UNKNOWN | 8 | 8427 | 0 |
| a | UNKNOWN | 10 | 2599 | 196 |
| a | UNKNOWN | 8 | 5823 | 0 |
| a | UNKNOWN | 6 | 2323 | 8 |
| a | VQ_Supervisor_Hotline | 1 | 78 | 88 |
| a | UNKNOWN | 8 | 5178 | 958 |
| a | VQ_ElderlyAndDisable | 3 | 523 | 65 |
| a | VQ_Supervisor_Hotline | 1 | 148 | 13 |
| a | UNKNOWN | 5 | 3061 | 143 |
| a | UNKNOWN | 6 | 1876 | 0 |
| a | VQ_Supervisor_Hotline | 1 | 12 | 5 |
| a | UNKNOWN | 8 | 3105 | 1 |
| a | VQ_ElderlyAndDisable | 1 | 283 | 426 |
| a | VQ_Lang_English | 1 | 338 | 75 |
| a | UNKNOWN | 6 | 2147 | 8 |
| a | VQ_Supervisor_Hotline | 1 | 141 | 378 |
| a | UNKNOWN | 4 | 3602 | 147 |
| a | VQ_ElderlyAndDisable | 1 | 330 | 82 |
| a | UNKNOWN | 1 | 1243 | 0 |
| a | UNKNOWN | 7 | 2130 | 143 |
| a | UNKNOWN | 1 | 981 | 0 |
| a | VQ_Supervisor_Hotline | 1 | 345 | 438 |
| a | UNKNOWN | 5 | 3224 | 428 |
| a | VQ_Lang_English | 1 | 556 | 274 |
| a | UNKNOWN | 2 | 541 | 0 |
| a | UNKNOWN | 3 | 1148 | 0 |
| a | UNKNOWN | 2 | 1098 | 16 |
| a | VQ_Supervisor_Hotline | 1 | 15 | 4 |
| a | UNKNOWN | 6 | 1951 | 15 |
Sample Output
| Agent | Queue | Total Accepted | Total Engage | Total Wrap | Avg Call Length |
| a | UNKNOWN | 103 | 54537 | 2068 | 549.5631 |
| a | VQ_Supervisor_Hotline | 9 | 841 | 978 | 202.1111 |
Anonymous ,
Call Length = DIVIDE([Total Engage Time] + [Total Wrap Time] , SUM(Table9[Accepted]))
Total Engage Time = SUM(Table9[Engage Time])
Total Wrap Time = SUM(Table9[Wrap Time])
Regards,
HN
Anonymous
Thanks for your advice. I did so following your instructions yet I found a wired thing that makes an inaccurate result.
The data in the data field following your advice:
The data in the report view and the number was much larger than the data in data view:
Anonymous ,
You are creating Calculated Column,
You should be creating Measures and not Calculated Columns.
Regards,
Harsh Nathani
Anonymous
Oh it works!! thanks for pointing out my mistakes.
I hope you won't mind to answer me the following silly questions. I wonder what's the difference between Measure and Column, they are quite similar to me as both of them are working with Dax for calculation