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?
Maybe check the placement on your parenthesis? You might be RSUM-ing the entire formula rather than just the numerator, in which case you are actually adding up the total percentages each week. (And maybe that's how it got to 4,000%.)
( (RSUM( ( [Total Ticket Paid/Reserved Count] , [Zone Group] ) )) ) / ( [Total Seat Count] , [Zone Group] )
(RSUM( [Total Ticket Count] ))/ [Total Seat Count]