Hi everyone,
I'm trying to figure out how to identify first-time buyers for whatever performance is selected for the dashboard. The only way I've thought to do it so far is to create a FTB list for every performance and use that in Analytics, meaning the user would have to change the performance filter in the dashboard AND update the list used for the FTB widget to match.
Is there an easier way that I'm missing?
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.