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