Average Package & Ticket Price

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

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