I can work out how to count how many times a first timer visits thanks to previous discussions, but more simply want to know, how many shows in a season our buyers are buying
Is there a simple calculation for #cbooking for only 1 show in a season; # booking for 2 productions, etc etc
Thanks!
I use this formula which I've most certainly gotten from elsewhere on the forums!
SUM ( [Constituent ID] , IF ( [# of unique Performance] >=2 ,1 , 0 ) )
And then just change out the highlighted section depending on how many performances I want to track. I have also changed out '# of unique Performance' for '# of unique Production/Production Season'
Hope this might be what you're after!
That's brilliant! Thank you so much!