First-time buyers in Analytics

You can select First Performance Date or First Performance Name as one of your data points.

Thanks Madeline! I'm just not sure how to actually use the filter in the way I need.

I have a performance overview dashboard with a performance filter. I'd like a widget to show first-time buyers TO the selected dashboard perf without requiring the user to update the widget first perf filter themselves. Do you think this is possible?

I think you would be able to achieve this by using the First Performance Name data point.

I think what you're asking is, if the dashboard performance filter is subsequently filtered for a different performance, is there a way to have the First Performance Name widget adjust with it just based on the dashboard filter?  I don't think you can do this since they are two separate data points.  Is that what you're trying for?

Hi sorry for the delay, it's been a heck of a week.

Yes that's what I'm asking. It seems like there should be some way to do this without creating a list for every performance :/

You wouldn't have to create a list for every performance, but unless I'm missing a trick I think you'd have to adjust the First Performance Name element in the widget to match that of the performance you're filtering on each time you changed the filter.

Tell me I'm wrong, analytics-minded people!

I agree.  You want the First Performance Name to be = the filtered dashboard level performance (or within the performances for a selected Production Season) but I'm not sure of the Case logic for that filtering of filters.  I was thinking of First Performance Date > MIN(performance date) and First Performance Date < MAX(performance date) but that would be not helpful where you have overlapping Productions runs

I'm not sure if this will work for you and I don't remember where I got this from but this formula seems to sum the number of customers using First Performance Date.

 SUM ( [Constituent ID] ,
      CASE WHEN MAX( DDIFF ( [Days in First Performance Date] , [Days in Date] ) ) = 0
     THEN 1 ELSE NULL END
     )

Thomas..!! This is WONDERFUL and seems to have worked perfectly, thank you so much!!

I also appreciate the practical example of how to use the CASE statement!

Glad it works! I can't take credit though as I took it from someone else but can't remember who though

Looks like a Wallingford special 
https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/23488/sorting-first-performance-name-by-date-instead-of-alphabetically/66610

Hi, this is a great thread, but just trying to get my head around the suggested formula from Thomas: 

 SUM ( [Constituent ID] ,
      CASE WHEN MAX( DDIFF ( [Days in First Performance Date] , [Days in Date] ) ) = 0
     THEN 1 ELSE NULL END
     )

For this to work, am I right in that you would need to add a filter to the [Days in First Performance Date]?

If I needed to look at a series of performances within a Prod Season over the course of a year, is there a way to look at that as a whole, or do you need to filter for each date?
Thanks!

Hi Pryce,

This will count the constituent as a first-timer if their first performance date is within the scope of the dashboard/widget filters and widget groupings... So you don't need to filter on a given first performance date.

If you filter and group by production seasons, then within each visible production season, you'll have a count of constituents for whom their ticketed performance date from that production season was also their overall first performance date. If you go to a higher level, and look at the entire season, then those constituents for whom their first performance date falls within that season will be counted as first-timers in that season. All with the same formula.

Fantastic - Thank you Chris!