addCalculatedMeasure

addCalculatedMeasure(measure: Object)

[starting from version: 2.3]

This API call adds a calculated measure.

Calculated measure must have the formula property. You can create as many calculated measures for one report as you need, there is no limit to the number of calculated measures.

When you save the report, all the calculated measures will be saved as well and loaded when the report is restored.

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

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

Parameters

measure - the object that describes measure. This object can have the following properties:

Property/Type	Description
uniqueName String	The measure’s unique name. This property will be used as an identifier for the measure inside Flexmonster and as an identifier to remove the measure via API.
formula String	Represents the formula. It can contain: Operators and functions. Check out the full list. Numbers. Negative numbers can be used as well (see an example). Measures. A measure can be addressed using its unique name and an aggregation function. For example, sum("Price") or max("Order"). See a list of supported aggregations in Flexmonster's technical specifications. Calculated measures. To address another calculated measure, specify its unique name. For example, "Formula #1".
caption String	optional The measure’s caption.
grandTotalCaption String	optional The measure’s grand total caption.
active Boolean	optional Indicates whether the measure will be selected for the report (true) or not (false). active: false can be useful if the measure has non-default properties, but should not be selected for the grid or the chart.
individual Boolean	optional Defines whether the formula is calculated using raw values (true) or using aggregated values (false). Only for "json" and "csv" data source types. Default value: false.
calculateNaN Boolean	optional Defines whether the formula is calculated using NaN values (true) or using null values (false). Default value: true.
format String	optional The name of the number format that will be applied to the measure. All available number formats are stored in the report.formats property. For more information about number formatting, see Number formatting.

Example

The following example shows the calculated measure Average Quantity which is calculated as sum("Quantity")/count("Quantity") and will be added to the list of available measures but not selected for the report (active: false):

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

flexmonster.addCalculatedMeasure(measure);

Open the example on JSFiddle.

See also

Calculated values guide
removeCalculatedMeasure()
getAllMeasures()
getMeasures()