Help with formulas for trend analysis chart

[cfsutter]

I'm trying to create a trend analysis of average days open for tickets by month/priority in rolling 13 mos line chart. I have no problem getting the data itself and easily calculated the cumulative average per month with running totals. However, I quickly found that I cannot use a formula in a chart which uses two running totals for the calculation. The calculation I used is #RT total days open/#RT open ticket count. When I use this calculation the formula does not appear to be an option when I go to select the field to use for "Show Values". Obviously if I am going to trend average days open by month over a 13 mos period I need to be able to show the values for the average number of days.

Since I couldn't use the formula that calculated off the running totals I created a set of formulas using variables to calculate a running total. Again I had no problem getting the correct data, but I've run into a new problem. I can use the new formulas in the Show Values section but the report only shows the average value for the last of the months. While the correct data is being displayed in the report there must be an issue with the formula if the chart is not displaying all the months.

My formulas are below.

@Running Total Days Aging - placed in the Group #1 Header - @Month

WhilePrintingRecords;
NumberVar Aging;

Aging := Aging + {@Days Aging calculation};


@AgingDisplay - placed in the Group #1 Footer - @Month

WhilePrintingRecords;
NumberVar Aging;


The chart itself is placed in the Report Header, but I've tried it in every section with the same results. I feel pretty certain I must need something in the formulas to tell it to break on each month, but not reset. I do have my @month formula in "On Change Of" in the chart expert and I also have a @priority formula in the "On Change Of" section.

I'd really appreciate some feedback on this. I feel like I am overlooking something obvious in my formulas but am just not seeing it.

Thank you!

 

[kray4660]

As far as formulas and Charts, Ken Hamady has a good solution. But it requires the Chart to be in a sub-report. I believe his solution is in this forum. If not it should be easy to find on his site. It requires building strings which contain the data you need in the main report and passing that data to the sub-report for the chart. I hope this helps getting pointed in the right direction.

 

[cfsutter]

Thank you Kray4660. I did finally figure out what was wrong only to end up with a new issue that I think is what's keeping everything from working. This report is like a snowball of issues. I'll make a new post for my new issue, just wanted to thank you for your reply.