Calendar Heatmap
Similar to heatmap but instead of a matrix, the cells are days on a calendar.
Required Fields
table - the table to use
conditions - the conditions to apply to the chart
date_range - the range of dates to check
date_field - which field to collect the data on
Optional Fields
aggregate_type - the type of aggregate to use
aggregate_field - the field to use for a non count aggregate
Return Data
An array of objects. Each object represents a date and contains the relevant data.
id: the date in question
query: the encoded query that returns the information
value: the value at that date
Example Payload
A screenshot of the data in ServiceNow:
Last updated
