Timed Bars
Last updated
Last updated
The Timed Bar Chart allows you to look at counts of data in bar graph format over a time series.
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
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
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
A screenshot of the data in ServiceNow:
