Area
The Area Chart is similar to the Line Chart except that the area between the trend line and the X axis is filled.
The Area Chart will use the first color from the defined palette.
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.
Return Data
An array of objects. Each object is of the following format.
id: The date of the entry
value: The value of the aggregate
Example Payload
A screenshot of the data in ServiceNow:
Last updated