Hi all,
I'm trying to make a line chart that shows a running percentage of capacity sold for each zone in a facility. Each zone has a different number of seats, so it has to be percentage sold as opposed to just a running sum to properly show which is filling first. Ideally I think I also want this averaged across the perfs in a production season, but I haven't gotten that far yet.
The formula I've landed on doesn't seem quite right:
( (RSUM( ( [Total Ticket Paid/Reserved Count] , [Zone Group] ) / ( [Total Seat Count] , [Zone Group] ))) )
I have a separate value added for each zone and filtered each down.
In dashboard filters I have season type / season / production season and I've selected only one. Also perf status not cancelled, constituent ID not -999999.
I have days in order date on the X axis. I (theoretically) have percentage sold on the Y axis, though it goes above 100% so I don't think this is working properly.
I have also tried
And those didn't seem right either. Any ideas?
Hi Gabrielle,
Adding on to what's already been offered... remove the Constituent ID not -999999 filter. This is a technique for removing unsold seats from the scope of the widget.
I suggest removing Zone Group from the formulas altogether and instead put that in the Break by panel.
Then you can be left with something like:
RSUM ( [Total Ticket Paid/Reserved Count] ) / ( [Total Seat Count] , ALL( [Days in Order Date] ) )
Ah, these changes did the trick!
I think I understand what was happening now. Thank you all!