I'm trying to look at first time vs. returning ticket buyers. I can't remember where I got these formulas from, but they seem like they should work. However, people who are most definitely not first time ticket buyers are being counted in that list. And some are showing up on both lists! Do I need to add filters to the forumulas?
First Time:
COUNT ( [Constituent ID],IF (MIN ( DDIFF ([Days in Date], [Days in First Performance Date] )) =0, MAX ([Constituent ID]), NULL))
Returning:
(Count ([Constituent ID])) - (COUNT ( [Constituent ID],IF (MIN ( DDIFF ([Days in Date], [Days in First Performance Date] )) =0, MAX ([Constituent ID]), NULL)))
I have the widget filtered to the specific performance.
Anne
Hi Anne,
I just checked my formulas -
For your returning buyers, I think there might be some extra parentheses that could be messing with the order of operations?
This is my returning buyers:
Count ( [Constituent ID]) - COUNT ([Constituent ID],IF (MIN( DDIFF ([Days in Date] , [Days in First Performance Date] ) ) = 0, MAX ( [Constituent ID] ), NULL))
See if that makes a difference?
My numbers stayed the same, unfortuately.
Hi Anne,I think you might have already done this, but have you tried looking at a performance and then selecting for your dimension, constituent ID, and then using the formula below to indicate if they are considered new by generating a flag of '1' if they are new? This might help troubleshooting and finding the constituent records that are being problematic:
IF ( MIN( DDIFF ([Days in Date] , [Days in First Performance Date]) ) = 0 , MAX ( 1 ) , NULL )
Where [Days in Date] is looking at performance date above. You could probably also copy the same formula and use a >0 to indicate those that are returning.
This here is my bookmarked thread on new vs returning as there are some great insights from Chris W on this topic.
First-Time Buyers in Analytics? - Reporting & Analytics - Forums - Tessitura Network
I added this as a value to my widget with my list of registrants and it works there. Thanks! Now just to figure out how to get the other widget to work.