I'm working in a "Performance Seats and Sales" widget is giving me a total ticket count higher than the capacity of my venue. It is reporting ticket sales of 104, the venue is 100, and we have 98 seats out. I know Analytics pulls data once per night so this is moment in time data. I have the formula "SUM([Ticket Count])" which seems to be working for other Dashboards I have put together. We did have several returns yesterday and they were resold. Those seats were not donated, rather unpaid and released. Any ideas why it's pulling in too many ticket sales? Thanks!
Hi Elizabeth,
Check that you are not counting returns. This one got me and I had to add SLI Status is only Seated Paid or Ticketed Paid for what we wanted to count.
([Total Ticket Count], [SLI Status])