Aggregation
Type
Constant String ('auto', 'sum', 'min', 'max', 'avg' or 'none')
Since
2.6.0
Description
When loading a fact into a store, the system tries to evaluate its aggregation function from the SQL-expression (this is the 'auto' mode, which is the default value for this property). If the system is not able to evaluate the function (e.g. it may use a database-specific and unknown function), you can set the aggregation manually here.
Especially for "COUNT(DISTINCT ...)" aggregations, you have the possibility to set the aggregation here, because without manual configuration the system would throw an error message (count distinct cannot be aggregated, but sometimes the distinct is only used for database reasons and the values can be summarized with 'sum').
If you set the mode to 'none' the system will not rollup the fact at all and fill all upper levels with NULL values.
Examples
Offline aggregation = "sum"
