Hello all! Taking a leap with what might be a very elementary question and hoping you can help!
I want to create a widget that will give me a 5-year comparative report on my total membership numbers on a given date. For example, I have tried to create a formula from the Active Member Count that will take the current date and pull the membership totals on that date one year ago, two years, and so on. No success!
Do you all have a formulas, widgets, or tips on how to accomplish this?
Hi Shelley, when adding [fields], if they don't turn blue in your formula after copying and pasting, you'll have to find them in the data browser and re-add them. They don't auto-populate the same way functions do.
I think the third video on this page might have some examples of adding fields to a formula
https://www.tessituranetwork.com/Items/Videos/Training/Analytics/Webinar-Collection