Forum Discussion
Plot multiple years data on one chart
Many thanks for the quick response Greg.
If I put the year as a legend it does indeed plot each year as an individual series, each with its own colour. However each year is not plotted ontop of each other (with a x-axis of Week01 to Week52 or something equivalent), the series are plotted end to end with an x-axis scale of 2015 to 2018.
I have the "Week01" to "Week52" column in my date table, but when I try to plot against this scale it corrupts the moving average calculation and what gets plotted (or displayed in a table) is the last sum of orders for each week.
Cheers,
MIchael.
Also just noticed that if I plot the years as seperate series (years as legend) then the 91 day moving average calculation doesnt work for the first 91 days as it treats the prior years data as a different set.
Is there any way the moving average can be continuous but each years data is plotted on top of each other?