YtD KPI aggregation by year

[duncan]

Hello @JRoz !

Do you ultimately want your users to be able to able to switch between YoY or MoM?

If you just want to do this by year and have it be dynamic, I would recommend using a solution similar to the one below:

Dynamic YTD Calculation depending on todays date for a count of Number of Events

Hi, I’ve got a dataset that includes the number of events that happen in a year. For a year on year comparison I would like to only include the “Year to Date” data for every year depending on today’s date. e.g. if Today’s date is 21st of August 2023. I would only want to include events that are in the dataset for every year that are before 21st of August 2022, 21st of August 2021, 21st of August 2020 etc. I’ve included examples in the screenshots below to illustrate what I’m looking for: [i…