I have a data associated with month and calendar year.
like this
[Calendar Year/Month]
Calendar Year
Jan-18
2018
Feb-18
2018
Mar-18
2018
……………..
2018
Dec-18
2018
Jan-19
2019
Feb-19
2019
Mar-19
2019
………………
2019
Dec-19
2019
Jan-20
2020
Feb-20
2020
Mar-20
2020
………………
2020
Dec-20
2020
Jan-20
2021
Feb-20
2021
we have various dashboards with time axis by month and by year.
now for the yearly line chart , rather than 2021 YTD ( as in this table it is as of Feb 2021) I want to show 2021 moving annual total, which would be the total from Mar 20 to Feb 21.
so the year time axis of line chart would be 2018, 2019, 2020, 2021( but actually it is 2021 Feb MAT)
is there a good way to set variable or edit at load script to achieve this without screwing up monthly data?
