Hi,
I need to do some set analysis on a data set where I need to count the values in a field by this year/month, the same month last year and the same month 2 years ago, effectively giving me a month average. I have a date field (in 'dd/MM/YYYY' format) and also a Year/Month field (in 'MM/YYYY') format. My dimension is currently by the Year/Month field and measure is the count of values. The graph I am trying to replicate is below and the Rolling Seasonal Average is the line I am trying to replicate.
Any assistance would be greatly appreciated!
Many thanks!