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
We don't use discounts (our admission is free), but could you use Mode of Sale to differentiate between the two? Since all discounts were done on site and sources were only used on the web.
Hi Chelsea - I wonder if the differenced in the breakout is to do with the pricing rules qualifying tickets vs tickets with pricing rules applied? If you add the 'pricing rules' from the seat & tickets details you should be able to see if this is the difference in your breakout. Q = ticket that qualified the pricing rule for the discount & R are the tickets the rules where applied to. Discounts don't use qualifying rules so that might be the difference?
You could get both discounts to show in the same widget using bucketing - create a bucket for the tickets with pricing rules & then also a bucket for those using discounts & one showing overall ticket numbers
Your bucketing for pricing rules would use the pricing rules from the pricing rules section & then you could optionally select which rules to include in the ticket numbers.
you would create buckets for each as required & end up with something like (discount column blank as we don't use them like you do)
or Mode of Sale - as Anne already suggested!
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.
The problem is I do not want them separated in this widget. I need the total number of both. The MOS will still separate it.
Example: If we sold 25 CT Summer Free tickets online (using source code), and sold 75 CT Summer Free tickets in-person (using discount), I need the widget to just tell me that we sold 100 CT Summer Free tickets.
Oh! I misunderstood. Can you filter on the amount of the ticket?
That still isn't clear enough for my staff. I basically need the impossible I think. The pricing rule number needs to be combined with the discount number. For example (the same example I just gave Anne): if we sell 25 CT Summer Free tickets online (using source code) and 75 in-person (using discount), I just need the widget to tell me that we sold 100 CT Summer Free tickets.
What do you mean by "Amount of the ticket"? Like dollar amount?
Yes. If they are all free, can you filter to just tickets that are $0? Or do you have comp tickets too?
I think you could still do this with bucketing - ( [total ticket count] , [pricing rule] ) + ([total ticket count] , [discount type] )
Good idea Jo. Use the separate widgets to confirm the total.