Charts 1

[Legion13]

I am trying to chart a running total on workorders that are grouped by month. If I set the chart on change of reportdate it gives me totals up to the change, i.e. for 3/2000 I get the total through the end of 2/2000 and what I want is the total through the end of 3/2000. How do I get around this?

 

[kenhamady]

What version of CR?
Charting running totals is a new v8 feature, and you need an advanced chart.

Since the group is monthly, your group chart will give you one subtotal per month, and therefore one bar per month. What do you want the chart to look like?




Ken Hamady-

http://www.kenhamady.com

http://www.kenhamady.com/

 

[Legion13]

CR8. And I do want one bar per month. The problem is that the totals for the running total do not match the chart for the same period.

RTotal0 - Jan. = 10 Chart - Jan. = 0 (no bar)
Feb. = 15 Feb. = 10
Mar. = 25 Mar. = 15
Apr. = 37 Apr. = 25
May. = 49 May = 37

So in the chart it is showing the values for the previous month's running total. Thank you for your response!

 

[kenhamady]

I did it and I see the problem.

The running totals are evaluated on the first record of the group for the chart, but they aren't complete until the last record of the group.

It looks like Seagate didn't think about that when they allowed charts of running totals.

I tried several alternates and couldn't come up with a workaround.

Sorry. Ken Hamady

http://209.41.46.214/

 

[Legion13]

Ouch! Thanks for looking into it for me. I wracked my brain too and could find nothing to get past that. You can't seem to chart formulas with variables in them either or I could use my formulas I have in the report now. Anyway, thanks again.