Forum Discussion
Handled % overall
I have a table with Ticket number,Country, Month & HC. I have to calulate the handled %
Formula = total ticket/ Avg( HC).
I am getting issue when i need to find the overall for a collection of month. Their the formula shoule be
Overall= Avg ( Monthly handled %).
As per below table for india Hadled % will be For July =5/626=0.8% | Aug = 7/592 = 1.2% | Sep = 7/657 =1.1%
As per the required formula its should be:
Overall Handle % = Avg(0.8 %,1.2%,1.1%) = 1.0%
| Contacts | Country | Month | HC |
| TIC-5214 | INDIA | July, 2019 | 626 |
| TIC-5672 | INDIA | July, 2019 | 626 |
| TIC-5653 | INDIA | July, 2019 | 626 |
| TIC-5652 | INDIA | July, 2019 | 626 |
| TIC-5647 | INDIA | July, 2019 | 626 |
| TIC-6068 | INDIA | August, 2019 | 592 |
| TIC-6338 | INDIA | August, 2019 | 592 |
| TIC-6330 | INDIA | August, 2019 | 592 |
| TIC-6297 | INDIA | August, 2019 | 592 |
| TIC-6289 | INDIA | August, 2019 | 592 |
| TIC-5920 | INDIA | August, 2019 | 592 |
| TIC-5861 | INDIA | August, 2019 | 592 |
| TIC-7248 | INDIA | September, 2019 | 657 |
| TIC-7226 | INDIA | September, 2019 | 657 |
| TIC-6891 | INDIA | September, 2019 | 657 |
| TIC-7272 | INDIA | September, 2019 | 657 |
| TIC-7195 | INDIA | September, 2019 | 657 |
| TIC-7178 | INDIA | September, 2019 | 657 |
| TIC-7148 | INDIA | September, 2019 | 657 |
My bad. I must have got distracted and didn't finish the measure. Only got the numerators. Please try this updated expression.
Avg Monthly Handled = VAR __summary = ADDCOLUMNS ( SUMMARIZE ( Table, Table[Country], Table[Month] ), "@count", CALCULATE ( COUNTROWS ( Table ) ), "@avg", CALCULATE ( AVERAGE ( Table[HC] ) ) ) RETURN AVERAGEX ( __summary, DIVIDE ( [@count], [@avg] ) )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
3 Replies
Please try this expression, replacing Table with your actual table name
Avg Monthly Handled = VAR __summary = ADDCOLUMNS ( SUMMARIZE ( Table, Table[Country], Table[Month] ), "@count", CALCULATE ( COUNTROWS ( Table ) ) ) RETURN AVERAGEX ( __summary, [@count] )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
in the measure that you gave i am not able to understand wer we are calculation the total Ticket count and Avg of HC. Bec when i use the formula it is not giving me corect valuse, Can you please check and confirm.
My bad. I must have got distracted and didn't finish the measure. Only got the numerators. Please try this updated expression.
Avg Monthly Handled = VAR __summary = ADDCOLUMNS ( SUMMARIZE ( Table, Table[Country], Table[Month] ), "@count", CALCULATE ( COUNTROWS ( Table ) ), "@avg", CALCULATE ( AVERAGE ( Table[HC] ) ) ) RETURN AVERAGEX ( __summary, DIVIDE ( [@count], [@avg] ) )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
