I have a dataset where I'm showing the number of events in specific weeks across 2020 and 2021. I would like to have an average line for each year, but am unsure how to achieve this.
@Chris McClellan You very kindly answered a very similar question. I'm unsure how to link to it, but I'm sure they're closely related.
4 answers
Ah, I understand the problem now :) It's just how you create the formula for the reference line.
@Ayinde Hammed solution is good as well, but if you want to use the same logic as I was using before, it's this :
The key is the calculated field when you don't have a measure, and it's ...
if YEAR([Year]) = 2020 then 1 end
workbook attached
