User Forum

Hello.  How can I generate a report that shows activity by hour?  Instead of a report showing tickets opened at 9:25am, 9:37am and 10:18am, I want to the report to show two tickets opened between 9:00am and 10:00am and one ticket opened between 10:00am and 11:00am.

Thanks!

-Scott

 Good Day Scott,

Thank you for your inquiry. Below are some custom fields added via the CUSTOMAHD.TXT. The Hour of Ticket fields will return the hour the ticket was opened as a number between 1 and 24. The MonthDay field will return the month and day the ticket was opened.

These fields can be used together or seperately to achieve the results your looking for. In testing these fields, I applied count formula to Incident #, added Hour of Ticket field, Added OpenDate with criteria of "Today", and toggled visibility on the OpenDate field (It must not be visible). This will give the count by hour for tickets opened today.

If you use larger time spans with open date, you can include "Month Day of Ticket" - there will be groupings by day.

The file is located in the C:\Program Files\OakTree Solutions\ON2008 directory on Report Builder machines, and C:\Program Files\OakTree Solutions\ON2008\www directory on Web Generator machines.

The CUSTOMAHD.TXT file can be edited with the entries listed below:

[Field]
CR
Hour of Ticket (DST)
datepart(hh,dateadd(ss, CR.open_date - (4*3600), '1/1/1970'))
num
CR
Daytime Groupings

[Field]
INC
Hour of Ticket (DST)
datepart(hh,dateadd(ss, INC.open_date - (4*3600), '1/1/1970'))
num
INC
Daytime Groupings

[Field]
INC
Month Day of Ticket (DST)
convert(varchar, datepart(mm,dateadd(ss, INC.open_date - (4*3600), '1/1/1970'))) + '/' + convert(varchar, datepart(dd,dateadd(ss, INC.open_date - (4*3600), '1/1/1970')))
for
INC
Daytime Groupings

[Field]
CR
Month Day of Ticket (DST)
convert(varchar, datepart(mm,dateadd(ss, CR.open_date - (4*3600), '1/1/1970'))) + '/' + convert(varchar, datepart(dd,dateadd(ss, CR.open_date - (4*3600), '1/1/1970')))
for
CR
Daytime Groupings

[Field]
CR
Hour of Ticket (EST)
datepart(hh,dateadd(ss, CR.open_date - (5*3600), '1/1/1970'))
num
CR
Daytime Groupings

[Field]
INC
Hour of Ticket (EST)
datepart(hh,dateadd(ss, INC.open_date - (5*3600), '1/1/1970'))
num
INC
Daytime Groupings

[Field]
INC
Month Day of Ticket (EST)
convert(varchar, datepart(mm,dateadd(ss, INC.open_date - (5*3600), '1/1/1970'))) + '/' + convert(varchar, datepart(dd,dateadd(ss, INC.open_date - (5*3600), '1/1/1970')))
for
INC
Daytime Groupings

[Field]
CR
Month Day of Ticket (EST)
convert(varchar, datepart(mm,dateadd(ss, CR.open_date - (5*3600), '1/1/1970'))) + '/' + convert(varchar, datepart(dd,dateadd(ss, CR.open_date - (5*3600), '1/1/1970')))
for
CR
Daytime Groupings

Thanks, Brian.

I'll work on this and let you know if I have any other questions.

-Scott

Hello, Brian.

I copied the fields you created into the customAHD.txt file and reopened Navigator, but I don't know where to look to find them.  The Admin User Guide states to save the file to the application directory.  Isn't that C:\Program Files\OakTree Solutions\ON2008?  Should I be looking for a custom folder where all the custom fields exist, or do the custom fields integrate into the Report Fields tree?

Thanks,

Scott

I found it!  Thanks!  -Scott

SDBase:

Hello, Brian.

I copied the fields you created into the customAHD.txt file and reopened Navigator, but I don't know where to look to find them.  The Admin User Guide states to save the file to the application directory.  Isn't that C:\Program Files\OakTree Solutions\ON2008?  Should I be looking for a custom folder where all the custom fields exist, or do the custom fields integrate into the Report Fields tree?

Thanks,

Scott

 

 I assume you found the above stated custom fields in the Requests and Incidents Report Type reporting trees. In a folder named: Daytime Groupings

The semi-colon character ";" in the customahd.txt file is used as a comment character. Any line the starts with ";" is not parsed by the field loading program.

Thank you,

Brian Holesapple

Yes.  I thought it was like a REM statement, but wasn't sure if some of the lines were already being used in my environment.  At least now I've gotten my dumb question out of the way for a while!