• Replies 4 replies
  • Subscribers 701 subscribers
  • Views 120 views
  • Users 0 members are here
Options
Related

First Time Buyers for a specific event returning following year

Emily Davies
$organization

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!

  • $organization

    Hi Emily,

    Try changing "years in first performance date" to "days in first performance date." Your days difference part of the formula is trying to calculate between days and years, so perhaps that's why it's not quite working. I hope that's the quick fix you needed!

    Count ([Constituent ID], IF(MIN(DDIFF([Days in Date],[Days in First Performance Date]))=0 ...

    Happy analyzing,
    Christine

  • $organization in reply to Christine Wingenfeld

    If that adjustment to your formula doesn't work, here are two other things to check with your calculation:

    - Verify what value you're using for "days in date," I know I've messed up formulas intending to grab a performance date but instead grabbing campaign start date or some other date field. (Someone at TLCC had a great presentation one year that "It's always the dates...")

    - Check what filters you have on the dashboard and widget to see if they could be interacting with your calculation. For example, how you have "all( [Production Season]) which overrides any production season level filters, if you also have a season or performance filter, you may need to consider how to incorporate those as well such that it's a factor in one part of your formula, but not in the second.

    Happy analyzing,
    Christine

  • $organization in reply to Christine Wingenfeld

    Thanks for your reply - I gave all of that a try and still getting 0! No idea what is going wrong. 

  • $organization

    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?