runQuery(query: SliceObject)
[starting from version: 1.6]
Runs a query with specified rows, columns, measures and reportFilters from the SliceObject and displays the result data. Use this method to rearrange hierarchies on the axes or to compose a new report based on the current data source.
| Parameter/Type | Description |
|---|---|
| query SliceObject | A new slice. Can contain only rows, columns, measures, and reportFilters properties of the SliceObject. |
let slice = {
rows: [
{ uniqueName: "Country" }
],
columns: [
{ uniqueName: "Color" }
],
measures: [
{ uniqueName: "Price" }
]
};
pivot.runQuery(slice);
Open the example on JSFiddle.