1

I'm trying to calculate a 'loyalty' score on Users. I have an Entries field history, with Entries like 2023, 2022, 2021 etc.
I want to calculate the number of consecutive years, going backward from the current year. So for example, a user with 2023, 2022, 2021 would have a loyalty score of 3. A u...