cancel
Showing results for 
Search instead for 
Did you mean: 

Average in SAP Analytics Cloud

bongielondy
Explorer
0 Kudos

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

View Entire Topic
Dhiwa
Participant
0 Kudos

create three calculations - Total_Repair_time, Total_Tickets, Average

Total repair time: (Aggregation)

Total Tickets: (Aggregation)

Average: (Calculated Account)

Data:-

Output Chart: