Hello! I'm trying to set up a widget that will show each performance in a season and the number of constituents and/or tickets that came from first-time buyers. I found a post on the analytics forum with a formula from
Chris Wallingford that seems to work, but it shows each individual constituent. What I need is just a count per performance of first-time buyers -- I don't need to know who they are. Has anyone set something like this up?
Thanks!AnneThe Historic New Orleans Collection
Hi Anne,
I believe the below formula is what you'd want to use is this below, for an aggregate count of new buyers by performance.
Your dimension can be a performance id, season, or production.
Formula to use for New Buyers:
COUNT ([Constituent ID],IF (MIN( DDIFF ([Days in Date] , [Days in First Performance Date] ) ) = 0, MAX ( [Constituent ID] ), NULL))
In my example, I have performance ID and code as my dimension.
My values are unique constituents and new buyers (formula above).
Sounds like the formula that you were using might have been the IF clause only from the above formula.
Hope this helps.
Hi Michael, Thank you for this! I will give it a go today. It sounds like just what I was looking for.