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?
Hi Chris, they don't really have to be in the same cube. It's a "nice to have" not a "must have" and purely for upper leadership's benefit. Ideally they'd like to have everything in one big widget so it's easy to download into Excel. Hopefully some day we'll be able to download whole dashboards into Excel and there will be peace among the nations!
Hi Jennifer,
I'd be interested in hearing why they want it in Excel?
I haven't worked with our CEO and CMO long enough yet to know exactly why but I suspect its due to their comfort level. Our CEO is a next-level Excel user and the CMO goes along with him. It's what they know, what they're used to and where he's most comfortable. When we finally go back to the office I'll try my hardest to get him into Tessitura and dashboards!
This is the same for our CEO who is used to excel and only wants things in the exact prehistoric format that he's used to having. Trying to get upper management into Tessitura and analytics is an up hill battle that will never win so we have to try and replicate every dashboard to look exactly like existing excel reports before they will consider replacing excel with dashboards. I've also had the 'can we have it in excel' question numerous times
Unknown said:I've also had the 'can we have it in excel' question numerous times
From InfoMaker, to SSRS, to T-Stats, to Analytics... A question as old as Tessitura itself. :-)
I've found a strange correlation between that question and my Zoom connection mysteriously dropping out
Sorry for my delayed here. Heath broke my Internet.
Is it just formatting, like fonts and having an Excel ribbon, and just having a quaint, familiar space? Are they wanting to further manipulate or even visualize the numbers they've received in Excel? Is this their way of collecting snapshots? Other...?
And to Chris J...