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.
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?