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 really I need the Paid amount to be all layers and I am getting them both per ticket and in Value.
Hi Mary.
This might be the issue i was getting the other day with my ATP calcs. In TR_PRICE _LAYER do you have ranks in your price layers?
"If you look at TR_PRICE_LAYER_TYPE, the Ticket Count in Analytics counts all Ticket Price price categories for this field. If multiple Ticket Price price layers exist for a performance, the Ticket Price price layer with the min start date and min price layer type rank is counted - as all of your Ticket Price Layers are the same value, they all get counted hence the inflated value." Maria Christas to me
As soon as i ranked my ticket price layers the double counting went away.
Cheers,
Heath
Heath Wilder Wasthis problem only found in 15.1.x or did you see this in the 15.0.x series of Tessitura?
Hi Tom,
Price Layers were introduced in Analytics in 15.1.x. If you have a look under the Price Layers in Analytics note under the 15.1 Tessitura Analytics changes at https://www.tessituranetwork.com/Help_System_v151/Content/v15_1/Tessitura%20Analytics%20Changes.htm it does indicate that the Ticket Price later with the min start date and price layer type rank is counted, however I can confirm that the rank column does exist in 15.0.x if you wanted to update that now.
Maria
As Maria says - you'll have that fun in 15.1
(15.0 was aok)