How to write cumulative statistics

[rgould]

Help!!!

I am running a report pulling data from one table.

Example:

Calls Presented : 6
Calls Answered : 5
Talktime :543

This is taken using a paramenter field to allow me to specify a date range.

What I would like to do is add onto the report a cumulative section that will specify totals from day one, rather than be included in the date range I specified for the current data.

Can anyone help?

Thanks,

R.

 

[synapsevampire]

Try posting example data and expected output.

Text descriptions of a specific format leave too much to the imagination.

If you just want a total of something for a given day, try a Running Total.

-k

 

[rockysewl]

I assume this data is from a call centre monitoring system where primary data collected would be something like call_in (datetime), call_answered (datetime), etc.

To total all the call details into a summary report that shows data specific to a date range and overall - you may use 2 methods.

Method 1. Create a subreport based on the same table that only uses the end date parameter for the main report. That is the record selection is call_in >= day1 and call_in <= end_date parameter.
Include in the subreport running totals for your data. That is: Count of call_in, Count of call_answered, Sum of (call_answered - call_in). The running totals are grandtotals evaluated for the whole of the report (no grouping) and placed in the subreport footer.
Place the subreport in the report footer or header of the main report depending on where you want it to be displayed.
the result will look something like.

Method 2. Use only the end date parameter for record selection and use call_in >= day1 and call_in <= end_date parameter to find your dataset.
Group your report by date and conditionally suppress all groups/detail where the date is not in the date range specified. Place running totals calculations in the group footer evaluated for the data field and reset on change of group. This will display the Running Totals for the days in the date range.
In the report footer include the Running totals as per method 1. This will display the overall running totals for the range from day 1 to end_date.

Hope this helps
rockysewl