Hi gurus:
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?
Much appreciation for any ideas.