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

[N1kh1l]

bongielondy

Follow the below approach.

• In your story create a table with Sates and Repair Time

• Now create a calculated measure Ticket Count of type Aggregation and Count dimension as shown below.

Result:

• Create another calculated measure Average Time as shown below.

Result:

Can also plot the same

Hope it helps !!

Please upvote/accept if this helps.

Nikhil