I have a report that runs against a Help Desk ticketing system.

 

I need to show the total number of tickets closed in a month and the number of tickets on a Year To Date basis.

 

I also need to show the average resolution times per month and average resolution time on a Year to Date basis.

 

I have a formula called @TotalIncidentsCount:

 

WhilePrintingRecords;
Shared Numbervar array TotalMonthIncidents;

Shared Numbervar MonthIndex := Month ({probsummarym1.close.time});
(TotalMonthIncidents [MonthIndex] := TotalMonthIncidents [MonthIndex] + 1;
           TotalMonthIncidents [13] := TotalMonthIncidents [13] + 1;)

 

Then, for each month, I have formulas (TotIncidents01, TotIncidents02...TotIncidents13) that display the totals per month

 

TotIncidents01:

 

WhilePrintingRecords;
Shared NumberVar array TotalMonthIncidents;
TotalMonthIncidents[1];

 

The information then looks like this:

 

January   February    March   YTD

4                   5             7        21

 

I then have a section where I average the total resolution times per month.

 

I have a formula that totals the averages called @Averages:

 

WhilePrintingRecords;
Shared Numbervar array TotalMonthAvg;
Shared NumberVar array TotalMonthSum;
Shared Numbervar array TotalMonthIncidents;

Shared Numbervar MonthIndex := Month ({probsummarym1.close.time});

(TotalMonthAvg [MonthIndex] := TotalMonthAvg [MonthIndex] + (Sum({@TotalAliasSecondsDuration}) / {@TotalIncidentsCount})) ;
          TotalMonthAvg [13] := TotalMonthAvg [13] + ({@TotalAliasSecondsDuration}/{@TotalIncidentsCount};)

(TotalMonthAvg [MonthIndex] := TotalMonthSum[MonthIndex]/TotalMonthIncidents[MonthIndex];
    TotalMonthAvg[13] := TotalMonthSum[13]/TotalMonthIncidents[13];)

 

Then, for each month, I have formulas (TotIAvg01, TotAvg02...TotAvg13) that display the averages per month.

 

WhilePrintingRecords;
Shared NumberVar array TotalMonthAvg;
TotalMonthAvg[1];

 

My question is: How do I create a chart where I can graph the total number of incidents and the average of the resolution time?

 

When i go to select data for the chart, my formulas are not listed.

 

Can I not chart these?