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

Sample data for the Support Tickets by Day and Hour chart template
Day of WeekHour BlockTicket Count
Monday9am-12pm42
Monday12pm-3pm38
Monday3pm-6pm29
Tuesday9am-12pm35
Tuesday12pm-3pm33
Tuesday3pm-6pm25
Wednesday9am-12pm31
Wednesday12pm-3pm30
Wednesday3pm-6pm22
Thursday9am-12pm33
Thursday12pm-3pm31
Thursday3pm-6pm24
Friday9am-12pm27
Friday12pm-3pm24
Friday3pm-6pm18

How to use it

How to adapt the support tickets by day and hour template

  1. 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
  2. 2 Export tickets with their created time, then count them by day and time block.
  3. 3 Use the local time the customer submitted the ticket so the blocks match your support hours.
  4. 4 Keep the days in calendar order on the x axis.
  5. 5 Use shorter blocks, such as one hour, if you staff in hourly shifts.
  6. 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.

Make your own heatmap in seconds

InstaCharts makes data visualization easy, so you can build clear reports without design experience.