Reference line with average over year

[Kmilla]

Hello everyone,

I have a bar chart representing my volumes for each month-year. I want to add a reference line representing the average level of my volumes for the current year. I have been trying a lot with functions avg, rangeavg, aggr, but still I can't find the solution.

I tried (unsuccessfully) for example :

RangeAvg(volumes,[date.autoCalendar.Year]=year(now()))

avg(aggr(volumes, [date.autoCalendar.Year]=year(now())))

Thanks in advance !

[ChiragPradhan · Accepted solution]

Hi,

See attached.

If it is what you are looking for, consider marking it as resolved.