Slope
The Slope Graph gives you a straight-forward look at how values are trending against two different time periods.
Required Fields
table - the table to query.
conditions - the conditions to apply to the chart
group_by - the values grouped by
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.
first: the value at the start
group: The display value of the group by field
second: the value at the end
Example Payload
A screenshot of the data in ServiceNow:
Last updated