Hello!
I would love to know if anyone has found a way to report on active membership count on a given historic date (regardless of when the expiration date). For example, I want to know how many memberships were active one year ago, regardless of if that membership is now lapsed or is still active. Knowing how many memberships were active one year ago, 2 years ago, etc, is incredibly helpful for tracking growth over time.
I can see counts based on expiration date in a given fiscal year, but this is not quite what I'm looking for.
Anybody cracked the code?
I feel like something very similar is going on here:
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/33977/counting-memberships-in-the-past-creating-formulas-in-analytics
And I thought there was another conversation about it that was longer, but I'm not finding it now.
Here's another, from longer ago:
community.tessituranetwork.com/.../84770