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
  • getAllMeasuresAsync

    [starting from version: 2.9]

    getAllMeasuresAsync(): Promise<Object[]>

    Returns a Promise object that resolves to an array of all available measures. See the array’s structure in getAllMeasures.

    Example

    pivot.getAllMeasuresAsync().then(measures => {
    measures.forEach(
      item => console.log(item);
     );
    });

    /* getAllMeasuresAsync method returns array of objects
    [     
    {
    "aggregation": "count",
    "availableAggregations": [
    "count",
    "distinctcount",
    "percent",
    "percentofcolumn",
    "percentofrow",
    "percentofparentcolumntotal",
    "percentofparentrowtotal",
    "index",
    "differenceofcolumn",
    "differenceofrow",
    "%differenceofcolumn",
    "%differenceofrow",
    "runningtotalsofcolumn",
    "runningtotalsofrow"
    ],
    "caption": "Count of Category",
    "calculated": false,
    "grandTotalCaption": "Total Count of Category",
    "label": "Count of Category",
    "uniqueName": "Category",
    "type": "string"
    },
    {
    "aggregation": "count",
    "availableAggregations": [
    "count",
    "distinctcount",
    "percent",
    "percentofcolumn",
    "percentofrow",
    "percentofparentcolumntotal",
    "percentofparentrowtotal",
    "index",
    "differenceofcolumn",
    "differenceofrow",
    "%differenceofcolumn",
    "%differenceofrow",
    "runningtotalsofcolumn",
    "runningtotalsofrow"
    ],
    "caption": "Count of Size",
    "calculated": false,
    "grandTotalCaption": "Total Count of Size",
    "label": "Count of Size",
    "uniqueName": "Size",
    "type": "string"
    },
    ...
    ]
    */

    See an example on JSFiddle.

    See also

    getAllMeasures
    getMeasuresAsync
    getAllHierarchiesAsync
    getRowsAsync
    getColumnsAsync
    getReportFiltersAsync