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 Chris - luckily I am not dealing with Multiple Price layers.