Group and count by time increment?
Posted: Wed Jun 09, 2010 10:50 am
I need a report that summarizes the total tickets handled every half-hour.
Example:
9:00 10 tickets
9:30 5 tickets
10:00 25 tickets
etc....
My database contains the time the ticket was created:
9:01
9:14
9:20
etc...
Has anyone written such a report? Any help is greatly appreciated.
:biggrin:
Example:
9:00 10 tickets
9:30 5 tickets
10:00 25 tickets
etc....
My database contains the time the ticket was created:
9:01
9:14
9:20
etc...
Has anyone written such a report? Any help is greatly appreciated.
:biggrin: