So I am hoping to make something that is both useful internally for tracking and then can be saved to a PDF for show Partners.
Think Box Office Statement - but I have a few things I can't figure out if they are possible.
I have the widget for Capacity, Comp, Attended and Paid pretty much set: with Paid/Reserved for ongoing tracking.
The other part is where I have the question:
Is there a way to get the actual price to report in the breakout by performance? So the math actually works for ticket count x (price) = paid amount??
the request states - Number of Tickets sold at various prices.
And last for the second widget in a dashboard that is many pages how to get it to export to PDF with all the parts.
Thanks TAMATO friends.
Hi,
Breaking by Zone is necessary in order to get a distribution of Price Type values, rather than just the MAX across all zones. Zone was in Mary’s original post screen shot, so I neglected mentioning that specifically. As Heath mentioned, taking Paid Amount will be impacted by editable and dynamic pricing. It will be a Max Paid Amount in that Price Type + Zone combination. You could switch that MAX to AVG if thats more aligned with you goal measure within each PT+Z. If you’d rather see the initial prices you’ve SET for the PT+Z, try Ticket Home Value...or Ticket Value for current prices.
So there is no way to have Analytics replace/replicate the Box Office Statement report (but combine the layers)?
I assume if you have TR_PRICE_LAYER_TYPE with ranked layers you should get all layers appearing
Looking at the Box Office Statement it has rows for Ticket Face Value rather than Pricetype a bit like this. I'm using Price type Catagories instead of filtering each of the Values only because I'm lazy. But it that kind more like what you are after?
Heath - That gets me close - but once I add Ticket Paid Value to the Rows my Price layers split again... So I think i need to look at my Ranked Layers... will be back in touch tomorrow once I make some changes.
Son of a monkey! I think we have an analytic coffee tomorrow (2am my time) if you want to chat. I'm going to bring up price layers and ranking.
I won't be able to make the call tomorrow.. but will let you know if I manage to win my rank battle!
Mine looks like this if it helps
My fees are still showing broken out.
Ranked 1 and 13
what else have is missed?