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.
Thanks, Chris! Since this is for 2022 we don't have any weeks without tickets so this should work.
Great Anne,
AND, I misread your OP above. If you put that formula in an Indicator widget, filtered to 2022, it'll give you the overall average weekly, as opposed to the week-by-week average.