Week Heatmap

The Week Heatmap allows you to see what times of the week are busiest for a given ServiceNow table. This can help you make staffing and support decisions.

Keep an eye on the record limit when creating a Week Heatmap to ensure it covers the timeframe you are wanting to analyze.

Required Fields

• table - the table to use

• conditions - the conditions to apply to the chart

• date_field - which field to collect the data on

• record_limit - the maximum number of records

Optional Fields

N/A

Return Data

An array of 168 objects. Each object represents an hour and day of the week. Each object contains the following key/value pairs

• day: the day of the week

• hour: the hour in the day

• id: the hour and day in a string with the following format "(hour):(day)"

• query: the query that returns the day and hour of the week

• value: the value on that day/hour pair

Example Payload

A screenshot of the data in ServiceNow: