Heatmap
Last updated
Last updated
Represents data where the individual values contained in a matrix are represented as colors
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
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.
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
A screenshot of the data in ServiceNow:
