Hello friends-
I've got a widget for total tickets sold yesterday. I'm currently using an Order Date filter with Date=Yesterday, but I think I may need an adjustment because it includes things like a subscriber exchange. For example, if a subscriber exchanges a pair of tickets out of one performance and into another, then my widget says I sold 2 tickets. I'd like for the widget to say 0 because technically, I didn't sell any tickets yesterday. It was just an exchange.
I've played with ticket type, and that didn't do it. I was trying to do something with Order Value because maybe if the order value was greater than $1, it would include only the true sales. Have you faced this? Any advice?
Do you by chance use an exchange MOS? If so, you could filter out that MOS from your widget!
We don't use that, but what a great idea!
Use the Finance Cube and exclude the Transaction Type Ticket Change.
That makes sense. All the other widgets in my dashboard are in the Seats Cube so can I have a dashboard that has widgets from another cube?
Sure can. When you are creating the new widget you can select a new cube from the drop down in the top right.
Terrific! Thanks! This is spot-on for getting total ticket rev from yesterday. How might I see the # of tickets sold yesterday?
Neil Cole | Customer Service Specialist Principal | neil.cole@state.mn.us
o: 952.431.9213 | MNZOO.ORG
13000 Zoo Boulevard Apple Valley MN 55124
Connecting people, animals and the natural world to save wildlife.
You're right about the Total Ticket Count part. My challenge seems to be getting an accurate number for the total ticket count. For example, if a subscriber exchanges a pair of tickets out of one performance and into another, then my widget says I sold 2 tickets. I'd like for the widget to say 0 because technically, I didn't sell any tickets yesterday. It was just an exchange.
When I do the same thing in the Finance cube trying to get to revenue, as you showed above, it's spot on. I would get $0 for daily revenue if a subscriber swapped out $100 worth of tickets from one show to another. What I'm trying to get is that exact same figure, just represented in actual tickets. The "Total Ticket Count" doesn't subtract out the tickets a subscriber returns when doing an exchange.
Do you use separate price types for subscriber tickets? Maybe even a separate price type category? Or maybe you use a particular promo source for exchanges? You could suppress those if you do. If not, and if we're talking about the wider issue of both subs and single ticket buyers being able to exchange, I've found that pairing "yesterday" numbers with "all time" numbers has helped paint a more accurate picture.