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!
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