Please help me understand how Ticket count works in the Seats and Tickets cube of analytics. It's not pulling same data as in the canned Attendance by performance report (even accounting for the fact that analytics only updates once overnight). The count is right in a 123 indicator widget (Total Ticket sales) but not a pivot table widget (Pricetype breakdown- which also isn't showing all the pricetypes). What am I missing? We have another attendance dashboard using Ticket count and it's off too.
Hey Shelley. Looks like difference between Pricetype Breakdown and Atendance by Performance is one seat Designated Driver - maybe that was purchased in the hours between your last analytics load around midnight and when you ran the report?
Those missing pricetypes (with the red line) sound like a filter on the widget it your Indicator is showing different values. Your Total Ticket Count value is not Total Ticket Paid Count so comps should be ok there.
Also your 13+ are there but your 21+ , Disco and Package are missing. Open the widget, check the Filters tab (not design) on the left check if there are no pricetype category filters in there. If you want to pop over the .dash I can have a look