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!