Need a special offer?Find out if your project fits.
+
All documentation
API reference
  • API Reference for older versions
  • 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()