This object is used to specify field members that should be expanded or drilled down.
{
tuple: string[],
measure: MeasureIdentifierObject
}
| Property/Type | Description |
|---|---|
| tuple String[] | Consists of unique names that identify the member in a row/column. |
| measure MeasureIdentifierObject | optional Use the measure to expand/drill down a member for a specific measure when:
measure is null, the member will be expanded/drilled down for all measures in the slice. |
The following example shows how to specify which field members should be expanded or drilled down:
slice: {
// Other slice properties
drills: {
columns: [
{
tuple: ["order date.[2019]"],
measure: {
uniqueName: "Quantity",
aggregation: "sum"
}
},
],
},
expands: {
rows: [
{
tuple: ["country.[japan]"],
},
],
},
}