Skip to main content

Custom Aggregates

Informer uses aggregate keywords to interpret large Datasets in Reports. These functions calculate a value based on the input, which Informer uses in Visuals to display information.

Adding a custom aggregate​

Enter an aggregate keyword while editing or configuring a Visual:

The Series tab with the Value field Custom tab and an Expression field
Adding a custom aggregate.
  1. In the edit window of a Visual, open the Series menu.
  2. Open the Value Field dropdown.
  3. Click the Custom tab.
  4. Enter the aggregate function into the Expression field.

Aggregate functions​

Select the function based on the desired output and enter the correct syntax.

  • Sum: sum:<field>. Calculates the total value of a numeric Field across all records. For example, sum:salesAmount finds the total sales amount.
  • Average: avg:<field>. Finds the mean value of a Field, useful for understanding the central tendency. For example, avg:orderValue finds the average order value.
  • Minimum: min:<field>. Finds the smallest value in a Dataset. Works on numeric and date Fields, so min:orderDate identifies the earliest order date.
  • Maximum: max:<field>. Finds the largest value, across various data types. For example, max:shippedDate finds the latest shipping date.
  • Value Count: value_count:<field>. Counts the number of non-null entries for a Field, useful for understanding the volume of data. For example, value_count:orderId counts the number of orders.
  • Cardinality: cardinality:<field>. Counts the number of distinct non-null values for a Field, useful for understanding the diversity of data. For example, cardinality:customerId counts the number of unique customers.
  • Count: count. Counts the number of items in each group of aggregated data. For example, count after grouping by shipRegion counts the number of orders per region.
Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Reports.