addCalculatedMeasure

addCalculatedMeasure(measure: Object)

[starting from version: 2.3]

Adds a calculated value.

Note You can add calculated value only for reports based on the "json", "csv", and "api" data source types.

Learn more about calculated measures in this guide: Calculated values.

Parameters

Example

In the example below, we add the "Average Quantity" calculated value. The formula is sum("Quantity")/count("Quantity"). The calculated value will be added to the list of available measures and selected for the slice (active: true):

let measure = {
  formula: 'sum("Quantity")/count("Quantity")',
  uniqueName: "Average Quantity",
  caption: "Average Quantity",
  grandTotalCaption: "Total Quantity",
  active: true
};

pivot.addCalculatedMeasure(measure);

Live example

See also

• Calculated values
• removeCalculatedMeasure()
• getAllMeasures()
• getMeasures()