Customer Experience chart template
Support Tickets Heatmap Template
Customer support ticket volume by day of the week and time block.
See when support tickets arrive by day of the week and time of day. The template colors each cell by ticket count, so the busiest times stand out.
Support Tickets by Day and Hour
A live heatmap drawn from the sample data below. Click Edit this template to change it.
About this template
What the support tickets by day and hour chart shows
Monday is the busiest day in the sample with 109 tickets, and Monday between 9am and 12pm is the busiest block with 42. Friday is the quietest day with 69 tickets, and Friday afternoon has the fewest at 18.
Tickets arrive most in the morning across every day of the week. A heatmap makes staffing patterns like this easy to read without a table of numbers.
About the sample data
Counts every ticket created in the help desk over the last 13 weeks, bucketed by the local time it was submitted. A ticket that was reopened later still counts once, on the day it was first created.
Sample data
Sample data for the support tickets by day and hour template
The template loads these 15 rows. Keep the same columns, replace the rows with your own numbers, and the heatmap redraws to match.
Day of Week
Columns of the grid
Hour Block
Rows of the grid
Ticket Count
Cell color
| Day of Week | Hour Block | Ticket Count |
|---|---|---|
| Monday | 9am-12pm | 42 |
| Monday | 12pm-3pm | 38 |
| Monday | 3pm-6pm | 29 |
| Tuesday | 9am-12pm | 35 |
| Tuesday | 12pm-3pm | 33 |
| Tuesday | 3pm-6pm | 25 |
| Wednesday | 9am-12pm | 31 |
| Wednesday | 12pm-3pm | 30 |
| Wednesday | 3pm-6pm | 22 |
| Thursday | 9am-12pm | 33 |
| Thursday | 12pm-3pm | 31 |
| Thursday | 3pm-6pm | 24 |
| Friday | 9am-12pm | 27 |
| Friday | 12pm-3pm | 24 |
| Friday | 3pm-6pm | 18 |
How to use it
How to adapt the support tickets by day and hour template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Export tickets with their created time, then count them by day and time block.
- 3 Use the local time the customer submitted the ticket so the blocks match your support hours.
- 4 Keep the days in calendar order on the x axis.
- 5 Use shorter blocks, such as one hour, if you staff in hourly shifts.
- 6 Download the chart as a PNG, SVG or PDF, share it with a link, or embed it on a website. Sign up free to save it.
FAQ
Support Tickets by Day and Hour template FAQ
What data do I need for a heatmap?
Two category columns for the rows and columns of the grid, such as day and time block, and a number column for the color of each cell.
Can I upload raw tickets instead of counts?
Yes. Upload one row per ticket with its day and time block, and set the chart to count rows.
Is this chart template free?
Yes. Click Edit this template to open it in the InstaCharts chart maker with no account needed. Sign up free to save the chart, share it with a link or embed it on a website.
How do I use my own data with this template?
Open the template in the chart maker, then paste in your own spreadsheet or upload a CSV or Excel file with the same kind of columns. The new chart keeps this template's heatmap type, and you can pick which columns go on each axis.
Learn more about this chart type on the heatmap maker page.
More templates
Related chart templates
Top Reasons Customers Churn
Horizontal Bar ChartExit survey answers from customers who cancelled, counted by the reason they gave and ranked as horizontal bars.
View templateCustomer Satisfaction Ratings
Bar ChartHow many customers picked each star rating in the survey sent after a support conversation.
View templateNet Promoter Score Trend
Line ChartNet Promoter Score from the in-app survey for each month over the last year.
View templateCustomer Satisfaction Score
Grouped Gauge ChartSupport ticket ratings from 1 to 5, averaged for each support channel, with one ring per channel filling toward a perfect 5.
View templateBudget vs Actual Expenses
Grouped Area ChartBudgeted and actual expenses by month, useful for tracking spending against a plan.
View templateEmployee Turnover by Department
Grouped Line ChartMonthly employee turnover rate for sales, engineering and customer support over twelve months.
View templateSee all Customer Experience Chart Templates, or browse all chart templates.
Make your own heatmap in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.