Average in SAP Analytics Cloud

[#1]

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

[Dhiwa]

create three calculations - Total_Repair_time, Total_Tickets, Average

Total repair time: (Aggregation)

Total Tickets: (Aggregation)

Average: (Calculated Account)

Data:-

Output Chart: