Has anyone been able to set up a Widget or Dashboard that measures sales to with regard to Dynamic Pricing triggers. Meaning percentage of capacity by price type or by performance? I'd love to see what you have done...
Hi Mark -
I just recently set something similar up for us (see attached).
This report will list your shows by either date or production season (we use both), and then our price zones are listed along the top. The 'value' is just a function / formula that uses the TOTAL PAID COUNT & TOTAL SEAT COUNT fields.I then created several conditional formatting rules based on what percentages we want to track.
I also added a Production Season filter at the Dashboard level to try and allow someone to focus on a particular set of shows (as opposed to everything all at once). I'm not sure if this is the best way to set it up, so that part is still a work in progress.
Happy to answer any other questions if you have any!
. 3173._InventoryManagement.dash
Have you tried Chris WallingCuhel's Dynamic pricing Dashboard here https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/22034/sharing-dynamic-pricing-template
I love this little widget and have hacked it into many different things
Heath