Waffle

The Waffle Chart allows you to compare values against each other while also giving you an approximation of the percentage of a given value. These charts can be read as each block representing 1% of the whole.

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: