This is kind of specific, but I need to get a ticket count by zone for specific performances, and I cannot get anything other than 0. Someone smart (not me) changed the formula for this:
in my weekly single ticket report to this:
which gives me a number that basically matches the numbers in the ticket sales reports.
However, I cannot figure out how they did it. I'm trying to create a report that will show me ticket counts by zone, but my options seem to be SUM[Ticket Paid/Reserved Count], which gives me a value of 0 for every zone, COUNT[Ticket Paid/Reserved Count], which gives me a value of 1 for every zone, and DUPCOUNT[Ticket Paid/Reserved Count], which seems to give me every seat in the zone regardless of payment/hold/other status.
I tried changing the COUNT to [# of unique SLI ID], but I got a function syntax error: Unrecognized metadata identifier '[# of unique SLI ID]'
I do not know SQL, so I apologize for my ignorance, but I really just need to know how to get Analytics to show the actual number of tickets that have been either paid in full or reserved with a balance due. (I would settle for just paid in full - I am getting the same errors.) Anyone able to help?
If you're looking for the total count of tickets reserved, would SUM(Ticket Count) work? This would take into account paid and unpaid tickets- anything that was reserved.
You could then add a row for 'Zone' or 'Zone ID', and it should slice out correctly.
To re-create the formula you gave, I think it'd be this:
Does that help?
Sadly, no. It gives me 0 for every value. And changing it from SUM to COUNT gives me 1 for every value.
That is very odd. When I look at a widget on my end, the SUM(Ticket Count) and [# of SLI ID] is the same number.
I'm not sure why one would catch numbers for you, and one wouldn't. Does the re-creating of '[# of SLI ID]' work for you? Or is it still giving you the error?
There is something with the Price Layer Type that if it is not TICKET then Ticket Count does not work (on some versions of Analytics)
Do you have any thoughts on why it would work for one Analytics dashboard to make this change but give me an error on the other one? I must be missing something...
Also, MARY!!!! Hello! We miss you!!!
I have the issue when the Price Category is ANYTHING other that Ticket Price. (So all school things that are tuition) and in another forum post was told to make the SLI ID change to get counts.
HELLO Lindsay! if you email me the DASH file I am happy to look (and if you can check your price Layer in the performance that would be great!)
So the fact that I use B-Ticket Price instead of Ticket Price might be the problem? I'll send you the file.
Hi Lindsay!
Long time no talk!! That is 100% the problem. That field is looking for TICKET PRICE any other value will return 0.
Shana