Hi Folks,
Just thought I'd share my Seat Availability Dashboard some of which I briefly presented on at TLCC. The top bit of it is a Chris Cuhel special - his Dynamic Pricing board.
The availability widget has a lot of neat formulas that Chris Wallingford helped me with including filters and conditional statements. Discussion of the Conditional Statement in hte final column can be found here
There is also an example and a link to instructions for a barchart triggered Pulse Data Alert for when your availability drops and you want the dashboard to email you.
If you need a help with any of it please ask.
3107.SDC_S2Availability.dash
So I am trying to use this for a merchandise performance (uniform sales) and sadly all the Counts are coming up ZERO... any thoughts?
Work around for this you might try, using COUNT ([SLI ID]) or [# unique SLI ID]
OK - I can get what is sold - but what about available? looking for available inventory
Yeah...that's a tough one because unsold GA is grouped together into a single row a placeholder Seat Key and a >1 Seat Count that represents that total inventory, but without a Ticket Price layer, it's not giving it to you. And with only a single row and placeholder SLI ID, you aren't getting the expected count back for unsold seats.
Are we talking about a one-off thing here or several things all with the same total inventory before sales? If so, you could hardcode the inventory into an Available formula that's like e.g. 1500 - [# unique SLI ID].
Another thing we recommend at times is to put a $0 Ticket Price layer on the pricing setup. Then the counts will start showing up in Analytics.
Thanks Chris Wallingford - I have zones by size so likely need to setup the $0 ticket Price Layer.
Is this something that is going to be fixed in the future?
Hi Mary,
Yes, it's on the list to figure out how to support that.