Hi - Has anyone figured out how to pull the average package and ticket price in the Tickets/Seats cube yet? I tried searching for it, and didn't have any luck.
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:
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.