Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difficulties charting trends

Status
Not open for further replies.

cfsutter

Programmer
Oct 14, 2013
7
US
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 13 mos. 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.

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

Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top