Hi All,
I'm currently working in an Excel document to track sales / inventory for a company I'm consulting for and want to turn it into an Analytics widget to reduce workload. The aim of the Excel was to capture the status of all seats; the company was getting sales reports where they were technically 'sold out' but had only 1/3 of the house as ticketed orders. I had to then use other reports to find the status of their remaining inventory.
Current process; using four (4) reports (PT Category, Hold Availability, Performance Base Price & Availability + custom Sales Report), I record the following:
I've attempted to create the widget in Analytics, but when I'm encountering errors in some values like hold code filtering, available seats remaining and unpaid ticket count. Its probably formula based so any help would be greatly appreciated. NB: Some of the values across the examples won't match; the season has been rescheduled due to COVID so the dates are shifting.
Cheers,
Amy
ORIGINAL SPREADSHEET
ANALYTICS WIDGET
I can help you with that. Can you shoot me over the .dash file (weekend too late for you? I'm a bit smashed with a handover)
Thanks Heath - weekend is fine. I've emailed you :)
Cheers Jennifer Laing (Past Member) - a handover for a show not my job
Phew! i shall calm down now :-) I am still fighting the fight up here and another lot of new staff, so you will probably be hearing from me in the next few months (again!).