Hi @roblewis
Yes, it is possible to create a report showing what time of day the most tickets are created, using a bar chart with the hours of the day on one axis and the total number of tickets raised on the other axis for a given time period. Here's how you can go about building it:
- Log in to your SysAid Administrator portal.
- Navigate to Analytics > Reports.
- Click on the "Create new report" or "All reports" tab to start creating a new report.
- Choose 'Service Records' as the entity for your report.
- In the report configuration, you'll need to select the fields relevant to your report. For this specific report, ensure you include the 'Creation Time' or 'Request Time' field.
- Set the report type to 'Bar Chart'.
- For the X-axis, select the 'Creation Time' or 'Request Time' field and configure it to display the hours of the day.
- For the Y-axis, configure it to count the number of tickets.
- Apply any additional filters you need, such as a specific time period or ticket status.
- Save and run the report.
This will generate a bar chart showing the distribution of ticket creation times throughout the day for the specified period.
Thank you
Ive tried that, and yes it does what i asked, but it turns out i didn’t ask the right question :)
i would like to be able to run the report, and from the chart be able to identify (over a 6 month period) when the busiest times of the day are.
More specifically, I need to know if the workload between 4pm and 5pm is generally busier or quieter than other 1 hour periods during the day
so - 24 columns on the bar chart, one for each hour, height of column is qty of tickets created over a six month period
Is that possible, or am i asking too much?
Thank you