Clearly I'm using the wrong field to get average ticket paid amount. What field should i be using or what am I missing here? Any assistance is appreciated.
I've always had issues with the AVG function. I'll be interested in the solutions folks have.
Although, I suppose the most straight-forward solution would be to use [ (Ticket Paid Amount) / (Ticket Count) ], rather than any default AVG formulas.
Hi Richard! I was actually just talking about this with some of our Pittsburgh Analytics users. For ticketing, if you use the "average" formula in Analytics, it will also consider each price layer as a different value for calculating the average. So any fee layers are going to throw off your average. You might want to try creating a manual formula that is the [total paid amount] / [total paid count] to get a more accurate average.
I hope that helps!
~ Christine
Thanks - i guess the manual lifting is the way to go. Appreciated!
Thanks - manual lifting is the way to go - appreciate the response!