Heat map on number of tickets by hour to identify service desk contention.

[tomwilliams]

Hello,

I've tried searching for this, and not come up with much to work on, so here I am, I don't know JSM and I'm not wanting to export CSV and work formulas in Excel (by gentle with me).

I'm hoping to cast a report that shows our busy periods of each day, preferably by intensity of colour. The days would be layered over the top of one another with hour by hour on one axis and number of tickets created on the other, then intensity of colour or shade showing the number of days.

If the third axis (colour) is too much, that's fine, but currently I can't find much in the way of hourly report, except the very limited 5day round up.

How do people use ITSM to plan their desk coverage agreements without this type of metric?

Thanks in advance for any help.
Tom

[Tanya _DevAcrobats_]

Hello, Tom!

I just came across your question.

Have you found a solution to this?

You can easily create this type of report with Performance Objectives: Charts for Jira app, using the Heat Map gadget (by NaraSyst). The report would look like that:

In the x-axis you can choose to 'Date by':

Note that this is a paid 3rd party app developed by our team. 

Please let me know if I can be of further assistance.

Best regards,

Tanya