Hi all!
We're interested in looking at our occupancy as a percentage, with an overall target for our Season. In light of this, we want some insight into how we're performing against this target, specifically over the past 2 weeks of Orders. It's all working as we expect, but now we want a percentage - calculated by the SUM ( [Ticket Count] ) / SUM ( [Total Seat Count] ) ) / 100. This works as expected when looking at our overall occupancy, but falls over when we add an Order Date (for the last 2 weeks) as a Widget Filter.
I understand why this happens and I assume that bucketing is required to limit only the Ticket Count to the last 2 weeks of orders. I have some experience in bucketing but feel quite lost with the different functions, I've been trying to use the IF function to enforce the order date range but haven't had any luck getting it working. I feel like I'm missing something really obvious, does anyone have an example of bucketing where you are only looking at Tickets purchased within a certain order date window? Or maybe bucketing isn't required and I'm missing something even more obivous.
I would really appreciate any guidance or advice anyone has. Thanks very much in advance.
Hi Samuel,
If I'm understanding, you may just need the ALL() function in your denominator to override the widget filter so that it's not limited to the past 2 weeks of orders.
( [Total Seat Count] , ALL( [Days in Order Date] ) )
Thanks so much Chris, it's now returning the value I expected. I figured I was probably overthinking it, I can think of a few more instances where that ALL function will come in handy. Thanks again!