Heatmap
Represents data where the individual values contained in a matrix are represented as colors
Required Fields
table - the table to query.
conditions - the conditions to apply to the chart
group_by - the field that determines the x-axis
second_group_by - the field that determines the y-axis
Optional Fields
aggregate_type - the type of aggregate to use. If none is provided 'COUNT' will be used.
aggregate_field - if an aggregate other than 'COUNT is used, an aggregate field must be provided to determine what to aggregate on.
Return Data
An array of objects. Each object is of the following format.
query: the encoded query that returns the correct results
value: the numerical value of the aggregate
x: the display value of the x coordinate
y: the display value of the y coordinate
Example Payload
A screenshot of the data in ServiceNow:
Last updated