Hello All,
I know the finance cube doesn't have a total tickets/seats sold option but does anyone have a work around for that? Some fun formula that delivers the same thing in a genius way? :-) I'm doing a "Yesterday's Sales" widget and ideally I'd like to include not only the revenue but also the number of tickets sold.
Jennifer Aprea
Hi Jennifer!
If you can filter the dashboard on Order Date = Yesterday, then you can add a widget that uses the Seats and Tickets cube, but that will respect the Order Date filter.
Hi Chris!
No way to get seats sold to show up by some fancy way in my finance cube widget then huh? Has to be in Seats and Tickets?
Correct. The high-speed nature of transactions in Tessitura, and the system's value as a financial subledger, mean a fairly clear relationship between transactions and orders, but a less clear between transactions and the items in those orders. Therefore showing Finance cube based monies and tickets in the same widget is not currently possible. So I can keep your needs in mind for the future, why do they need to be in the same widget?