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
}