Hi Everyone,
I'm trying to do an analysis of one particular event from 2023 which had 4000 first time buyers attend. I want to know how many of them returned to anything in 2024.
I looked at another post asking a similar question and got some great suggestions from there but when I use this formula:
Count ([Constituent ID], IF(MIN(DDIFF([Days in Date],[Years in First Performance Date]))=0 and ([# of unique Production Season ID], all ( [Production Season])) > 1, MAX ([Constituent ID]), NULL))
my result is always 0 and I'm certain that's incorrect! Any ideas what I'm doing wrong here?
Thanks in advance!
Hi Emily,
In addition to Christine's update, it would be helpful to confirm the context in which this formula is being calculated. Can you share either the dashboard file here, or the details of the dashboard filters, widget filters, and what fields are in the widget Row/Categories and Column/Break By?