getAllMeasures():Array

Returns a list of all available measures (both active and inactive) in the report.

Returns

Returns an array of objects. Each object is characterized by the following properties:

  • aggregation
  • availableAggregations – an array of available aggregations.
  • availableAggregationsCaptions – an array of captions of available aggregations.
  • calculated
  • caption
  • folder
  • format
  • formula – a formula if a measure is calculated.
  • grandTotalCaption
  • individual
  • name
  • originalCaption
  • uniqueName

Example

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.

What’s next?