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])
Hi Elizabeth
Also check your TR_PRICE_LAYER_TYPE setup. If you haven't ranked your layers you may end up counting each one of those.
Cheers
H
Which version of Tessitura are you running? I know in the earlier versions of 15, there were some incremental load problems that caused number creep like that.
if you pop this into SSMS it might help debug that for you. I really hope it's not counting returns though
use impresarioselect count(sli_no), sli_status_short_desc from bi.VT_ORDER_DETAILwhere perf_code = 'SS191101P'Group by sli_status_short_desc