Analytics formula to show how many patrons attended in 2023 and 2024, 2022 and 2023 etc

Hi There,

I'm still wrapping my head around analytics so apologies if this is a really obvious question.

I want to create a widget that shows me the year on year return rate of our patrons. So I'd like to know how many who attending in our festival in 2023 also attended in 2024, how many attend the last 5 years in a row etc (how many purchase annually vs every 2 years, 3 years etc). Does anyone have a great dashboard for showing return rates like this? 

Thanks in advance!


Emily 

Parents Reply Children