Essentially, I'm looking to compare one perf's running sum of ticket count vs the others in that production season, in the same chart, as it pertains. Or: how is this perf's sales doing over time, compared to the rest of the season?
I can get the total ticket count for a production season, in a running sum, with 'Order Days Prior to Perf' as the X-Axis. I can get the total ticket count for a performance, in the same format. But I can't seem to get both on the same chart. It brings up the Yellow Exclamation Mark of Doom when I do so:
I can do two sums, but not two rsums. I can't do one sum and one RSUM either. The RSUM isn't playing nice with anything, even another RSUM.
Within a widget filtered by Production Season, the formulas I'm using are: RSUM ( [Total Ticket Count] ) for the whole season's ticket count.
( RSUM ( [Total Ticket Count]) , [Days in Date] ) is what I have for the bucketed result, filtered by a single performance. Again- both work, but they don't work simultaneously
Is there a better way to do this? Having a nice visual for comparison would be powerful.
Here are a couple of ideas:
1. Add TRUE to your RSUM, so that it accumulate the sum continuously.
Something like: (RSUM ([Total Ticket Count], TRUE), [Days in Date])
Example:
2. Try adding Performance to the Break By part of the graph.
This graph has two RSUMS with Fiscal Year in the Break By part.
Now that I think about it a little more, I think that the TRUE part will only help when there is more than one dimension in the X axis. My graph has Day of Month and Calendar Sort Month. Without the TRUE in the formula, the RSUM would drop back down to zero for each month.
Use Heath's .dash.