Aster

The Aster Plot is similar to the Pie Chart and Donut, but adds an additional data point. The length of the slice is based on the value from the 'Weight by' field defined. For example, you can configure an Aster Plot to show the incident categories as the slices and weight by the average priority for each of those categories.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

• group_by - the primary grouping

• weight_by - the value the slices are weighted by

• 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.

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,
    'weight': 2.908
}, {
    'name': "2 - Medium",
    'query': "impact=2",
    'value', 1608
    'weight': 4.97
}, {
    'name': "3 - Low",
    'query': "impact=3"
    'value': 1587
    'weight' 0.95
}]

A screenshot of the data in ServiceNow: