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
Hey Anne,
Was it Nicola Cann post here
What's your First [Days In Date] represent? Performance Date?
First Time: COUNT ( [Constituent ID],IF (MIN ( DDIFF ([Days in Date], [Days in First Performance Date] )) =0, MAX ([Constituent ID]), NULL))
Because [Days in First Performance Date] is a single value and lives in the constituent dimension it shouldn;t be being filtered. So if you are getting odd results including people for whom this is not their first maybe throuw a row in there that is Customer ID &/or Performance Name and First Performance Name and track down some of the oddities. When I find a particularly odd specimen that is baffling me I usually try pulling parts of the formula into values or rows and seeing what unsuspecting results are coming out.
I'm usually curious as to what people, including myself, mean by First Time Buyers. In this case is it that the difference in the performance date for this Production and the date of the first performance in their entire record is 0. Just thinking about it in case this is their first purchase (ie: first and only order) with two performances (maybe the other is merch) and this is the performance with the latter date. As this is their first and only purchase do they qualify? In this case I'd want to know if this order date - their first order date is 0 days.
We don't sell merch via Tessitura. I'm interested in knowing for how many people this was the first event that they purchased tickets to. I'm really confused adding in the first perf name and most recent perf name. it is showing some people with none in both columns and counting them as returning ticket buyers.:
Any chance that they exchanged out?
For the FIrst perforrmance = History Symposium / Most recent= None (or the None None)
Maybe drill down to get their order_no or customer_no and have a look at their ticket history in their Tess record
This implies that their First Performance Date won't be populated in the way that you expect either and instead will show 1900-01-01, which is well before the event date to which they are actually first timers. As Heath said, check out the ticket history for those constituents and ensure it's being populated as expected.
I don't think so. We really don't deal with exchanges.
2023HistorySymposium.dash
I'm attaching my dashboard in case it helps anyone. Thanks!