Solved

Charting a running total, and the difference between the total records and this running total.

Posted on 2008-06-11
4
220 Views
Last Modified: 2011-09-08
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!
0
Comment
Question by:whitfa
  • 2
  • 2
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 150 total points
ID: 21762952
Can you sum using a summary function?

Running totals are evaluated in the last pass of building a report (known as the printing records pass).  Charts are built before that pass thus the data is not available.

Try Right click the field you want to summarize
CLick INSERT --> SUMMARY

If that doesn't work here is a method for using printtime formulas in charts
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf.asp

mlmcc
0
 

Author Comment

by:whitfa
ID: 21770516
Hi, thanks for your reply.

I don't think I can use either option.  I can't use the print time workaround as this report is already a sub report*, and I don't think I can nest them that far.

My chart should show week by week, the behaviour as described above.  The weeks are calculated as a datediff between a fixed date, and the Exit or Upgrade date, so show from week = -10 to week +10.  The Do Nothing people don't have a behaviour date attached to them, and this is why I can't chart them because they don't subtotal in any given week.

I can chart the running total of Exits and Upgrades (and stack them), but I can't add in the remainder of the population (Do Nothings) to make a 100% stacked chart.

*I tried doing this week by week cumulative behaviour in the main report, but because of other Grouping levels the series appears to spike and trough and spike again, when it should be an increasing line since it's cumulative.  I'm not sure that I can therefore pass an ordered week by week list to the subreport/ chart suggested in the workaround.



0
 
LVL 100

Expert Comment

by:mlmcc
ID: 21771760
You are correct that you can only nest subreports 1 deep.

DOn't know off hand.

mlmcc
0
 

Author Comment

by:whitfa
ID: 21824195
Hi, I managed to get around this one by labeling every "Do Nothing" as occuring @ week = -10, despite them not having a date in the records.  This way, I could bunch all my Do Nothings at the start of the running total, and chart it along with running totals of the Exit and Upgrades.

I did however find your workaround useful @mlmcc and employed it elsewhere in my main report.  I'll award you the points - not that you need them mate ;-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now