Charting a running total, and the difference between the total records and this running total.
Posted on 2008-06-11
Hi, I'm struggling with this one.
I'm wanting to chart cumulatively, the behaviour of my customers over time. So they either Exit, Upgrade, or Do Nothing. I want to end up with a 100% stacked chart of this behaviour week by week. For each record I am using a 1 or 0 for each @Exit and the same for @Upgrade. There is a date only for these two behaviours, which I am charting.
I'm using the sum of these fields in running totals; #Exit and #Upgrade, and failing miserably at calculating out the @Do Nothing's as Total Records - (#Exit + #Upgrade).
The chart won't let me include @Do Nothing, presumably because the Total Records has to be calculated at the end of the print. I've tried doing this using variables in the folumalae, but then these formulae don't appear in my chart data options. I've tried the Evaluate After options, but no cigar.
I've a feelng I'm making this overly complicated. Any help gratefully received!