Calendar Heatmap

Similar to heatmap but instead of a matrix, the cells are days on a calendar.

Required Fields

  • table - the table to use

  • conditions - the conditions to apply to the chart

  • date_range - the range of dates to check

  • date_field - which field to collect the data on

Optional Fields

  • aggregate_type - the type of aggregate to use

  • aggregate_field - the field to use for a non count aggregate

Return Data

An array of objects. Each object represents a date and contains the relevant data.

  • id: the date in question

  • query: the encoded query that returns the information

  • value: the value at that date

Example Payload

A screenshot of the data in ServiceNow:

Last updated