Line Chart with total line

[LoretaS]

Hi, I am creating line chart to compare each month solution rate. Is it possible to add avg/total one in the chart as well?

Example from the excel with total dash line:

I create pivot table with monthly/yearly data, so add totals it is possible, but how to add it in line chart as well?

[Chanty4u]

Add secondary measure 

Avg(Aggr(Sum(Solutions)/Sum(TotalCases), Month, Year))

[LoretaS]

Hi, How can I add secondary measure on this line chart when I have two dimensions? QS allows only alternative measure..

[Lech_Miszkiewicz]

create grouping total dimension and use it as a dimension of the chart - it removes all complexities from the expression and can be easily created in load script.

cheers

monthyear, grouping dim

202101, 202101

202102, 202102

202103, 202103

202101, total

202102, total

202103, total

..., ....