First-time buyers in a pie chart

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

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

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.