Simple Score

The Simple Score gives a total count of records based on the defined conditions. An example of this would be an incident backlog score.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

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.

• use_group_by - whether a group by is in use

• group_by - the value to group by

Return Data

An array with a single object that is a number representing the number shown.

Example Payload

A Javascript Object:

["1403"]

A screenshot of the data in ServiceNow: