I am still dealing with issues from our summer discounts from 6 months ago!
Here is the issue:
To make things easy for our Front Desk this year, instead of doing it all as a Promo/Source Code (like the year before which gave inaccurate numbers because the Front Desk forgot to switch the source code between orders) I created a Discount for the in-person sales and then kept the Promo/Source code for online sales.
This worked great in built out and for our front end; however, because pricing rules/sources and discounts are two completely different things, reporting on them has been a nightmare. I have 2 different widgets set up; one has the discounts, the second has pricing rules. The problem is the Total Attendance is the same for both, but the breakout is different and we don't know why. I don't know if I built the widgets wrong, or if its because I'm trying to get Tessitura to do something it simply won't.
What our org needs: Total number of attendance by Ticket Type for ALL discounts (discounts and pricing rules combined); separated by discount.
So basically I want to combine the two widgets into one clean widget.
Attached is the dashboard file (ignore the comp reason widget, that is completely correct and what we need).
CLM71223-CompReason&Discounts.dash
You could also try using Unique SLI ID with and Attended Flag = Y instead of using Attended Count to see if there is a difference two values. I no longer use Attended Count. We occasionally have performances with more than one pricing layer (even though not on purpose). The unique sli id with attended flag takes the issue away.