Good morning! I feel like this should be super easy, but I'm hitting a wall. I'm trying to find average weekly attendance for our museum admissions for the current FY. There's an example widget for average daily attendance, but when I try to tweak it for weekly I'm getting numbers that I know are way off. Does anyone have a widget for this already built?
Thanks!
AnneThe Historic New Orleans Collection
Hi Anne,
With Fiscal Week of Year (or Calendar Week of Year) for the Order, Attended, or Performance Date on Rows of a Pivot widget, you can divide the [Total Ticket Count] by [# unique Fiscal Year] . However, for each week it'll only divide by the number of years in which that week had tickets. If that isn't a factor, such that you never had whole weeks without a Ticket Count, then dividing by [# unique Fiscal Year] from that same date dimension should get you there.
Hi again, While this all makes sense in concept, I am still not very proficient in writing formulas in Analytics. I put this together before I got your response -- does it look like it is accomplishing the same thing?
I recommend [Total Attended Count] / [# unique Weeks in Attended Date]. To get that divisor, hover over the [Date] field in the ATTENDED DATE dimension. Select "More..." and then # of Weeks.
Thank you! I finally got it.