4.12. Aggregation node (= pivot table)

Note

A full video tutorial on the aggregation node is available here.

Icon:

• Number of inputs: 1.

• Number of outputs: 1.

Definition

An aggregation node lets you create pivot tables

Configuration

Using the aggregation node configurator you can:

• Add several row headers .

• Select a field to be pivoted (optional) .

• Add one or more measures :

  • Number - blank field = (*) count(*).

  • Average.

  • Sum.

  • Minimum.

  • Maximum.

  • Standard deviation.

  • Percentile - the percentile parameter can vary between 1 (1^er percentile) and 99 (99^ème percentile). 50 is the median.

  

Example

With the following configuration:

We therefore get: