First-time buyers in Analytics

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?

Parents Reply
  • 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

Children
No Data