Average Package & Ticket Price

Hello!

Fiddling with the 'Values' formula, I was able to get the following:

That seems to work, but I'll freely defer to more experienced Analytics users. I was able to pull in the total Ticket Paid Amount, who's formula would be SUM{Ticket Paid Amount), and change 'SUM' to 'AVG'.

Does this help?

That was my approach as well - you can also use the little widget to switch between SUM and other options: 

The AVG() aggregation should get you there if you don't use more than one price layer in your pricing setup, or if you're in v15.0.x which doesn't break out tickets and their amounts by price layers. In 15.1 the Seats and Tickets cube includes price layers, and unless a 15.1 widget is filtered to a single price layer, the AVG() function will take the average paid price layer amount instead of the average paid total ticket amount. That to say, you can also take the total paid amount and divide by a count of tickets... this will work with price layers.

Best,
Chris

Thank you, Nathanael and Alan!

Using AVG and Ticket Paid Amount worked.

I'm still a little unsure on what criteria to use for an average subscription package price. 

This morning, I tried using AVG function and package type and package code criteria in Package Detail. This is getting me a better number, but it’s still higher than what I have in T-Stats by about $25. I’ve been filtering out our facility fee price layers in Analytics and believe it should come out to less. If anyone has any insight into this, I'd appreciate it.