In the pivot table, every cell displays an aggregated value of raw data records. An aggregation function determines how the data records are aggregated into the value.
This guide describes which aggregation functions are available in Flexmonster and how to use them.
Note If you are using the custom data source API, you can implement custom aggregations.
The table below lists all aggregation functions supported by Flexmonster. To see which aggregations are available for each data source, refer to Flexmonster’s technical specifications.
You can also limit the list of available aggregation functions:
You can choose an aggregation in the following ways:
To choose an aggregation function for a measure via UI, use the sigma icon in the Field List:
Note You can control the visibility of the sigma icon using the showAggregations option.
To apply an aggregation to a measure in the slice, specify the name of an aggregation in the aggregation property:
report: {
dataSource: {
filename: "https://cdn.flexmonster.com/data/data.csv"
},
slice: {
measures: [
{
uniqueName: "Price",
aggregation: "average"
}
]
}
}
Note If the aggregation is not specified, its default value is either "sum", "count", or "min", depending on the field's type.
To change an aggregation function applied to a measure, use the runQuery() method:
const slice = pivot.getReport().slice;
slice.measures[0].aggregation = "distinctcount";
pivot.runQuery(slice);