Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.
All documentation
  • API Reference for older versions
  • 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

    Parameter/TypeDescription
    query
    SliceObject
    A new slice. Can contain only rows, columns, measures, and reportFilters properties of the SliceObject.

    Example

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

    Open the example on JSFiddle.

    See also

    getReport
    setReport