Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have requirement to show the two average amount reference lines in the bar chart.
Dimension used are Quarter
Measure : Amount
1. One for over the Quarters
2. Quarters Avg for each year
I was able to create the reference line for Avg(amount) over the years. But not able find the solution for second one. is it possible to do so?
Attached the screenshot for reference
If I understand correctly, you want the quarters avg reference line to change for every year (as per your picture)
I don't believe you can do it with a reference line as they only allow one value to be displayed
You can solve your problem by using a combo chart where the second expression (i.e. the line you want to draw) is based on an aggregation by year
Something like this:
Dimension: Quarter
1st measure (bars): sum(Amount)
2 measure (line): avg(aggr(avg(Amount), Quarter))