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 :)
@heath handover? what have I missed being out of the loop for so long?
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!).
These are my thoughts in case anyone wants to correct me. I'm the hollow dots.I've sent the dash back with some working formulas in there
Not sure if this is correct but I used Seat Status for the following:
Holds - filtered Available and Held to exclude any reserved or ticketed seats( [Total Seat Count] , [Seat Hold Code] , [Seat Status] )
Reserved Count - filtered on Reserved Unpaid( [Total Ticket Count] , [Seat Status] )