Hi,I am creating a dashboard with a filter for production season or performance and a sum of fees paid. I am using Finance cube and can not find a way to filter by performance. Am I in the right cube?
Thanks, Sabina
If you click the "Add Filter" button either in the widget or on the dashboard, scroll down to the Performance Detail section:
There are a number of ways to get at a single or group of performances.
Anne
Just be wary that only Per Performance fees will appear under that filter: Per Order (etc.) fees in an order that contained tickets to that Performance will not show up.
Thank you both. I added a filter to a graph showing POrder Fee Total by Fee. However, the graph is blank when I select a specific production season. I know that we sold tons of tickets with per seat fees for that production in the last 30 days. Any ideas? Thanks again.
Can you show the widget details? I'd like to see what fields you are using. We have an analytic Coffee! meeting tomorrow at noon eastern and we can work on it as a group there if you can't get it sorted out sooner.
It's a widget from the Tessitura dashboard examples
I'm sorry -- I wasn't clear. Can you click the edit pencil on the widget and show the setup of the widget?
Hi Sabina,
Financial data (Transactions and Payments) stored in Tessitura doesn't link fee money to performances. Order fees have already been touched on, but per seat fees as well because the stored transaction is a single amount for the whole order (per fee GL per order) and doesn't store it with a distinction for event (per fee GL per perf per order). So, there's no direct connection in the Tessitura financial data from the fee transaction back to the seats and performances generating the fee revenue.
The place in Tessitura where the distinction is made for seats and their specific fees resides in the order data rather than the financial data, meaning that if the link between seats and fees were to be included in Analytics anywhere, it would need to be in the Seats and Tickets data source. I can imagine how that enhancement might work and an Idea would help me track interest and use cases.
Thank you, Chris!