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