Need help with Monthly report using interval data

[zonger]

I'm getting an error when trying to sum a timestamp that is setup to print this section for each month.

sum( {iAgentPerformanceStat.LoggedInTime},{iAgentPerformanceStat.Timestamp})

My issue is my customer wants a monthly report but wants to select the time interval for that monthly report. So the report could be run for the month of March and April from 6:00 am to 9:00 pm. They want to see a total line for March and a total line for April. So I need to use interval data for this. I can do it for a daily report (setup group as print this secion for each day) but not for monthly.

Any ideas?

 

[GSanalyst]

Zonger,

You will need to determine how long your customer keeps their interval data on the database. I believe that the default may be somewhere around the 20 day range because the interval statistics are obviously more memory intensive. If your customer's range is similar to the default then the monthly statistics would be impossible.

The length of time that interval statistics are stored is configurable by the admin under the historical statistics option under the specific server you are reporting from.

 

[question911]

Zonger,

Make sure you have created a Group Section based on a formula. In this formula add this statement below:

TIME({iAgentPerformanceStat.Timestamp})

Then create a Parameter based on the iAgentPerformanceStat.Timestamp field. In the Parameter's Value Type property select "DATE"

Last of all, you may want to add a grand total in the Report Footer section.

Hope this helps.