Tracking NTF buyers who returned within the same year?

Hi Hannah!

Thanks for posting. There are a lot of first-time buyer discussions, but I don't think we have touched on NTF multi-buyers. I might try counting first-time buyers who have multiple performance dates. One of those is their first time, and all the others are returning. 

SUM ( [Constituent ID] ,
  IF (
    MIN( DDIFF ( [Days in Performance Date] , [Days in First Performance Date] ) ) = 0
    AND [# unique Days in Performance Date] > 1
    , 1
    , NULL
    )
)

So if, within the scope of the filters for the dashboard and widget, the constituents'' performance dates match their first performance dates... and also within the scope of the filters for the dashboard and widget, the constituents' have more than one unique performance dates... then they are returning first timers.

This assumes there's no grouping on categories/rows. If there needs to be such a grouping, then the [# unique Days in Performance Date] might need an additional ALL() filter to override that grouping. Otherwise it will only count performance dates within that grouping. E.g.

( [# unique Days in Performance Date] , ALL( [Production Season] ) )

A caveat that comes to mind here... is it okay if returning includes first timers who have future tickets who technically haven't returned yet? If not, then filter the value on Performance Date being in the Last 360 days, and if 360 days is not enough, go to Advanced and change it to the scope needed.

( [# unique Days in Performance Date] , [Performance Date last 10000] )

 ==> 

This all assumes that the scope of the dashboard and widget filters would include the dates of their returning. If not, and you need to count returning dates outside the scope of the dashboard and widget filters, then as with ALL() Production Season, and Performance Date last 10000, add a filter to the formula that overrides the scope of the dashboard/widget filters and expands into the necessary time period.

Best,
Chris

Hi Hannah!

Thanks for posting. There are a lot of first-time buyer discussions, but I don't think we have touched on NTF multi-buyers. I might try counting first-time buyers who have multiple performance dates. One of those is their first time, and all the others are returning. 

SUM ( [Constituent ID] ,
  IF (
    MIN( DDIFF ( [Days in Performance Date] , [Days in First Performance Date] ) ) = 0
    AND [# unique Days in Performance Date] > 1
    , 1
    , NULL
    )
)

So if, within the scope of the filters for the dashboard and widget, the constituents'' performance dates match their first performance dates... and also within the scope of the filters for the dashboard and widget, the constituents' have more than one unique performance dates... then they are returning first timers.

This assumes there's no grouping on categories/rows. If there needs to be such a grouping, then the [# unique Days in Performance Date] might need an additional ALL() filter to override that grouping. Otherwise it will only count performance dates within that grouping. E.g.

( [# unique Days in Performance Date] , ALL( [Production Season] ) )

A caveat that comes to mind here... is it okay if returning includes first timers who have future tickets who technically haven't returned yet? If not, then filter the value on Performance Date being in the Last 360 days, and if 360 days is not enough, go to Advanced and change it to the scope needed.

( [# unique Days in Performance Date] , [Performance Date last 10000] )

 ==> 

This all assumes that the scope of the dashboard and widget filters would include the dates of their returning. If not, and you need to count returning dates outside the scope of the dashboard and widget filters, then as with ALL() Production Season, and Performance Date last 10000, add a filter to the formula that overrides the scope of the dashboard/widget filters and expands into the necessary time period.

Best,
Chris