This object is used to identify measures when using different functionality, such as sorting, filtering, or setting table sizes.
{ uniqueName: string, aggregation: string }
Property/Type | Description |
---|---|
uniqueName String | The measure’s unique name. |
aggregation String | The measure's aggregation type. If the measure is calculated, set the aggregation to "none" . |
1) The example below shows how the MeasureIdentifierObject is used to set sorting in a row and a column:
slice: { // Other slice properties sorting: { column: { type: "desc", tuple: [], measure: { uniqueName: "Price", aggregation: "sum", }, }, row: { type: "asc", tuple: [], measure: { uniqueName: "Sales", aggregation: "sum", }, }, }, }
2) The example below shows how the MeasureIdentifierObject is used for filtering:
slice: { rows: [ { uniqueName: "Country", filter: { measure: { uniqueName: "Price", aggregation: "sum", }, query: { top: 5, }, }, }, ], // Other slice properties }
ColumnSizesObject
RowSizesObject
FilterObject
ValueSortingObject
sortValues()