getAllMeasures():Array
Returns a list of all available measures (both active and inactive) from the report.
Returns an array of objects. Each object is characterized by the following properties:
aggregation – String. The measure’s aggregation name.availableAggregations – Array of strings. An array of available aggregations for the measure.availableAggregationsCaptions – Array of strings. An array of captions of available aggregations. calculated – Boolean. true if the measure is calculated.caption – String. The measure’s caption.folder – String.format – String. The number formatting rule name.formula – String. A formula if a measure is calculated.grandTotalCaption – String. The measure’s grand total caption. individual – Boolean.name – String.originalCaption – String.uniqueName – String. The measure’s unique name. webdatarocks.getAllMeasures();
/* The method returns an array of objects:
[
{
aggregation: "sum",
availableAggregations:
["sum", "count", "distinctcount", "average", "product",
"min", "max", "percent", "percentofcolumn", "index",
"difference", "%difference", "stdevp",
"stdevs", "runningtotals"],
availableAggregationsCaptions:
["Sum", "Count", "Distinct Count", "Average", "Product",
"Min", "Max", "Percent", "Percent of Column", "Index",
"Difference", "% Difference", "Population StDev",
"Sample StDev", "Running Totals"],
caption: "Sum of Sales",
format: "currency",
grandTotalCaption: "Total Sum of Sales",
name: "Sales",
originalCaption: "Sales",
uniqueName: "Sales"
},
{
aggregation: "none",
availableAggregations: [ ],
availableAggregationsCaptions: [ ],
caption: "Revenue",
format: "",
formula: "SUM('Price') * SUM('Quantity')",
grandTotalCaption: "Total Revenue",
name: "Revenue",
originalCaption: "Revenue",
uniqueName: "Revenue"
}
]
*/
Try on CodePen.