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?
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