Hi friends,
I'm trying to create a pie chart to display "first time buyers" and "everyone else" who purchased tickets for a specific concert, but sure can't figure out how. Any thoughts?
Thanks for being smart!
Lesley
Hey Lesley!
I do this regularly for our productions. I use a value formula ( # of unique constituent ID , First Performance Name ) and filter to only the production I want. Then I add a second value that is the same thing but includes everything except that production in First Performance Name.
<- New Buyer
<-- Returning buyer
WOW thanks for this Madeline. I just used this tip on our own data and found that 41% of ticket buyers for our re-opening production of Red Riding Hood were first time buyers. That's amazing!
This is great!
I *KNEW* I knew smart people! Thanks Madeline!
Hey folks,
Madeline's formula is great, just thought I'd suggest the following too if it can work for you, as checking the difference between first performance date and performance date saves you from having to change the First Performance filter for each production.
COUNT ( [Constituent ID],if ( MIN ( DDIFF ( [Days in Date] , [Days in First Performance Date] ) ) = 0, MAX ( [Constituent ID] ) , NULL))
Thanks,
Carlo
Thanks Carlo! So to find the folks for whom this was NOT their first performance, would I just need to change the = 0 to >= 1 ?
I would have thought so, or !=0. But using that doesn't actually give me the expected result. Does anyone know why? To just get the total figure of folks who aren't first timers I usually just do Total Ticket Count minus all that formula.