Flexmonster Software License Agreement (“Agreement”) has been significantly revised and is effective as of September 30, 2024.
The following modifications were made:
The modified version of Flexmonster Software License Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after September 30, 2024, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Flexmonster Software License Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license under License Model or Maintenance after the effective date of any modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
This object is used in the /select request for the pivot table and the /select request for the flat table. It provides information about a measure and an aggregation function that should be applied to this measure.
{
field: FieldObject,
func: string
}
| Property/Type | Description |
|---|---|
| field FieldObject | The field selected as a measure. |
| func String | The aggregation function name. For each field, the list of supported aggregations is defined in the response to the /fields request. Supported values may include: "sum", "count", "distinctcount", "average", "median", "product", "min", "max", "stdevp", "stdevs", "none", or a custom aggregation.Note: for the fields of the "number" type, Flexmonster Pivot supports built-in front-end aggregations. |
1) Example of the /select request for the pivot table with the ValueObject:
{
"index": "data-set-123",
"type": "select",
"query": {
"aggs": {
"values": [
{
"func": "sum",
"field": {
"uniqueName": "price"
}
}
]
}
},
"page": 0
}
2) Example of the /select request for the flat table with the ValueObejct:
{
"index": "data-set-123",
"type": "select",
"query": {
"fields": [
{
"uniqueName": "country"
},
{
"uniqueName": "price"
},
{
"uniqueName": "quantity"
}
],
"aggs": {
"values": [
{
"func": "sum",
"field": {
"uniqueName": "price"
}
},
{
"func": "sum",
"field": {
"uniqueName": "quantity"
}
}
]
}
},
"page": 0
}
/select request for the pivot table
/select request for the flat table
FieldObject