runQuery

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.

Parameters

Example

let slice = {
  rows: [
    { uniqueName: "Country" }
  ],
  columns: [
    { uniqueName: "Color" }
  ],
  measures: [
    { uniqueName: "Price" }
  ]
};
pivot.runQuery(slice);

Open the example on JSFiddle.

See also

getReport
setReport