Timed Bars

The Timed Bar Chart allows you to look at counts of data in bar graph format over a time series.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

• trend_type - the type of trend to use (ex. date, week, month, etc)

• date_range - the range of dates to use

• date_field - what field we are using to check the dates

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

• use_group_by - whether the group by is in use

• group_by - the value to group by

Return Data

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

• (group): the value of the given group

• id: the date in question

• query: the query to get to the date

• stacks: and array containing the display value of each stack/group value

Example Payload

A screenshot of the data in ServiceNow: