Configuring the aggregation of number fields

Introduction

Most Widgets have configuration fields that require to generate a single number for each corresponding shape in the Widget.

Examples :

Chart : the chart line Y position of each point
TreeMap : the rectangle relative size for each rectangle
…

Since data is grouped in a Widget query (“for each point”, “for each rectangle”, …), numerical fields must be aggregated in order to give a single number for each Widget “shape”.

This operation is done with an aggregation function.

For Measure fields

For Measure fields (numbers), the following aggregation functions are available : Avg, Count, Distinct Count, Max, Min, Sum, STDev, STDevP, Var, VarP, Last.

Widget Measure aggregation functions v3.3

These functions absolutely require a number (except Count and Distinct Count, see below).
They translate to the corresponding functions in your source data engine (SQL, Oracle, … depending on your Data Source). Please refer to the corresponding documentation if you need to understand better these functions.

Using function `Last`

(new in Alpana 2020 R1)

The Last aggregation function allows to select the last value of the Measure field, according to an ordering based on a secondary field.
Typically, if a value changes over time, “@Last@ of value field ordered using date field” will select the last value of value field when ordered according to the date field.
In some typical dashboards, this can be considered the “current value”.

For Dimension fields

Dimension fields (strings, dates, booleans) can also be used to generate numbers for Widget queries.

The following aggregation functions are available : Count, Distinct Count.

These functions accept all data types.
They translate to the corresponding functions in your source data engine (SQL, Oracle, … depending on your Data Source). Please refer to the corresponding documentation if you need to understand better these functions.