on 07-03-2023 11:47 AM
I would like to calculate the Average Repair Time per State but the graph gives me the Sum per State. I have been working on the exception aggregation for hours. It doesn't work. Please help. Formula should be the Total Repair Time/No of Tickets
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
create three calculations - Total_Repair_time, Total_Tickets, Average
Total repair time: (Aggregation)
Total Tickets: (Aggregation)
Average: (Calculated Account)
Data:-
Output Chart:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.