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