Customer Average trendline for Total

[EQ]

Hi Experts,

I have a chart attached and I just want to calculate the average line for Total only, please see the screenshot.  So I created the second expression like below, but it does not work as expected.

sum(Amount)/Count(DISTINCT CalYear_Month)

I know there is trendline under expression tab, but it does not meet my request. Would a kind and enlightened please advise on my error, many thanks in advance!

[anushree1]

please Check if the attached is the Desired Result, I have used Reference Line within Presentation Tab here

[anushree1]

please Check if the attached is the Desired Result, I have used Reference Line within Presentation Tab here

[EQ]

Hi,

Yes, it looks good. But is it possible to add the line as the second expression and let its label show as a legend with the dimension with Region? Please see the attached screenshot.

[anushree1 · Accepted solution]

Please check the attached, its not a very dynamic approach though.

Please see the chart captioned option1

[EQ]

Hi,

The dimension Region will be limited to only 5 or 6, so I think the solution works for me. Great thanks!