Report Writer - Custom Report

pchaves

Can someone help point me in the right direction?

I'm creating a custom report for utilization of some interfaces but I'm having trouble figuring out how to narrow down the time frame. Trying to get a monthly report that will give me the previous month, but only Monday thru Friday from 8am to 5pm.

 

Thanks

kweise

pchaves,

You can do this on the Filter Results tab in report writer using the Hour of Day and Day of Week records.  Set it to Select records where all of the following apply, then add a new line and select Records where Hour of Day (24 hour format) is greater than or equal to 8.  Add another line stating Records where Hour of Day is less than or equal to 17.  You need two more line.  Record where Day of Week is not equal to Saturday and Record where Day of Week is not equal to Sunday.  Finally, on the time Frame tab, select Named Time Frame and set the time frame drop down box to Last Month.

Hope this helps.