Skip to content
Infoveave Help

Calculated Measures

calculated measures

Calculated Measures in Infoveave are custom metrics created by applying formulas to existing data fields. These measures enable you to perform complex calculations and visualize new insights from data. Unlike standard measures, which are directly derived from the dataset, calculated measures are formulated to meet specific analytical needs.

Configuring Calculated Measures

  1. Click on the + icon on the Calculated measure option to initiate the process of adding a calculated measure.
  2. Assign a descriptive name to your calculated measure that succinctly represents its purpose.
  3. Choose from options like None, First Date, Last Date, or Skip Date to define the behavior of date-based filtering for this calculated measure.
  4. Configure your calculated measure by defining its format, prefix, suffix, and precision.
  5. Utilize the checkbox option to decide whether to hide this calculated measure from specific widgets or visualizations.
  6. Provide a detailed description that elaborates on the context and significance of this calculated measure.
  7. Construct the formula by combining measures, dimensions, operators, and functions to derive the desired metric. Use the “@” symbol to reference existing columns and ensure you validate the formula to avoid errors.
  8. Click on the Validate button to validate the calculated measure.
  9. Click the Add calculated measure to include the calculated measure in your Datasource.