Diverging Bars

Diverging stacked bar charts are great for comparing data that has positive and negative value, such as agree/disagree or like/dislike.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

• group_by - the primary grouping

• record_limit - the maximum number of primary groupings to query

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.

• agg_field_duration - If a duration is used in the aggregate field, this must be provided with a value of true

Return Data

An array of objects. Each object is of the following format.

• name: The display name for the slice

• query: the query that the chart will apply on the slice

• value: the number for the data point in the slice

Example Payload

A Javascript Object:

[{
    'name': "1 - High",
    'query': "impact=1",
    'value': 1634
}, {
    'name': "2 - Medium",
    'query': "impact=2",
    'value', 1608
}, {
    'name': "3 - Low",
    'query': "impact=3"
    'value': 1587
}]

A screenshot of the data in ServiceNow: