Forum Discussion
Current and Previous Year Cumulative
Hi, I'm wanting to display current year (last 12 calendar months) and previous year (months 24-13) cumulative job count on a line graph to visualise the difference in jobs YOY. I can get month...
Thanks for the replies.
I ideally want to be able to use a page level date slicer to affect this. For example, Last 1 year should result in selections from April 2023 - March 2024 for CY, and April 2022 - March 2023. Next month (May), I'd need the calculations to move forward a month (May - April).
I'm assuming the "31/3" logic in the forumlas is hard-coding the date to always display March - April?