This seems like it should be very simple, but I'm clearly doing something wrong because my average monthly attendance is coming back as 1 for nearly every month. I'm trying to put together a widget to look at average monthly attendance for our museum admissions. I have one for daily averages and it works, but when I try to change it from daily to monthly something isn't working. This is the one that isn't working:
And this is the daily one that is:
I feel like I'm missing something really obvious on this one. Does anyone have a widget for average monthly attendance and can provide some insight?
Thanks!Anne
Playing with this here and I think the issue is it doesn't know what it's averaging. I think you need to plug in how many years to divide by.
The 'AVG' function has been heckling me whenever I try to use it for a while- I've always ended up spelling out the formula. Curious as to the reasoning here!
I think I've got it:
AVG evaluates at the grain of the rows being supplied to it. If we just AVG( [Ticket Count] ), it'll take the average of all the 1s and 0s over all the rows of price layers across all tickets and unsold seats in scope. For a sold ticket that could be a 1 and 2 0s and for an unsold seat 3 0s. Using AVG() raw isn't very common, but using it outside of Multi-Pass Aggregation is: AVG( [Order ID] , SUM( [Ticket Paid Amount] ) ) for example, for the average paid amount per order.
Do you keep a dashboard of SUM ( [Days in Date], [Total Minds Blown] )