Treemap

Uses color and block size to compare relative sizes across two groupings.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

• group_by - the primary grouping

• second_group_by - the secondary grouping

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 with a single object containing an object with an array of children, each representing the first group by, then each of them contains an object with an array of children containing the data of the second group by. This structure is outlined below

• children : array of children

  • name: the display value of the child

  • children: an array of sub children

    • itemID: the value of the second group by

    • name: the display value of the second group by

    • query: the query that contains the route to the data

    • size: the numerical value of the second group by

Example Payload

A screenshot of the data in ServiceNow: