Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.
Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.
Using the custom data source API allows you to decide which aggregations to enable in Flexmonster and support on the backend.
The supported aggregations can be defined in the schema for fields of a certain type or for each field individually. The list of aggregations supported by Flexmonster for the custom data source API connection is the following: "sum", "count", "distinctcount", "average", "median", "product", "min", "max", "stdevp", "stdevs", "none". Note: in the schema, only the above-mentioned aggregation names can be defined, since Flexmonster Pivot does not support custom aggregation names.
The backend can implement either all aggregations or some of them. Also, there is an option to define different aggregations available for different fields.
For the custom data source API, Flexmonster supports the following built-in front-end aggregations: "percent", "percentofcolumn", "percentofrow", "percentofparentcolumntotal", "percentofparentrowtotal", "index", "differenceofcolumn", "differenceofrow", "%differenceofcolumn", "%differenceofrow", "runningtotalsofcolumn", "runningtotalsofrow". These aggregations will appear in Flexmonster Pivot automatically if at least one aggregation is implemented on the backend (e.g., "sum"). Note that this feature is available only for the fields of the "number" type.
On the client side, the list of aggregations available for a specific field can be customized with the Mapping Object. The object has the "aggregations" property, which allows defining a list of available aggregations. That list can contain both aggregations supported on the backend and built-in front-end aggregations. To learn more about the "aggregations" property, refer to the Mapping guide.
You may be interested in the following articles: