Average Ticket Price

I have an Analytics Dashboard. I use the ticket paid amount and use max and average functions.
I filter out Subscription and Comp Price type Categories at the dashboard level. The great part is I can then add in Production season easily if I want.

HI Mary and Melanie,

This is great. Do know please that when using the AVG() function, that it's averaging that value across the rows of data, where there is a row per price layer per sub lineitem. So in the cases of seats or tickets comprised of multiple price layers, it's averaging the price layer values, not the aggregate sub lineitems. To account for that, a simple formula to SUM the value of which you want to take an average, and then divide by the COUNT of the thing across which you want to average....

[Total Paid Amount] / [Total Paid Ticket Count]

or 

[Total Paid/Reserved Amount] / [Total Ticket Count]

Thanks Chris - luckily I am not dealing with Multiple Price layers.

Thanks Mary and Chris!  Chris Wallingford would you have an example to show of how to input this formula?

Acutally I think I might have figured it out.  does that look right?  Then that would give the average?

Right, and are you already limited in this widget to only Single Tickets? If not...

Apply a widget level (or dashboard if it's a Single Tickets dashboard) on Price Type Category and select to include only Standard and Discount. That will remove Comps and Subscriptions from the average. If you want to include Comps in the calculation, LMK and I'll give you a little guidance.

I think it's best that you're using the "Paid" versions rather than the "Paid/Reserved" of these values to avoid including unpaid/partially paid tickets in the calculation. So that's good as you have it.

Right, and are you already limited in this widget to only Single Tickets? If not...

Apply a widget level (or dashboard if it's a Single Tickets dashboard) on Price Type Category and select to include only Standard and Discount. That will remove Comps and Subscriptions from the average. If you want to include Comps in the calculation, LMK and I'll give you a little guidance.

I think it's best that you're using the "Paid" versions rather than the "Paid/Reserved" of these values to avoid including unpaid/partially paid tickets in the calculation. So that's good as you have it.