Skip to content
Infoveave Help

Calculated Measures

calculated measures

Calculated Measures in Infoveave are custom metrics that you create by applying formulas to existing data fields. These measures allow you to perform complex calculations and uncover new insights from your data. Unlike standard measures that are directly derived from the dataset, calculated measures are designed to meet specific analytical requirements.

Configuring Calculated Measures

  1. Open the required table in the Datasource Designer.
  2. Select the column where you want to add a Calculated measure.
  3. In the Datasource Setup tab, click on the + icon next to the Calculated measure option to begin adding a calculated measure.
  4. Assign a descriptive name to your calculated measure that clearly represents its purpose.
  5. Choose from options such as None, First Date, Last Date, or Skip Date to define how date-based filtering behaves for this calculated measure.
  6. Configure your calculated measure by setting its format, prefix, suffix, and precision.
  7. Use the checkbox option to choose whether to hide this calculated measure from specific widgets or visualizations.
  8. Provide a detailed description that explains the context and importance of this calculated measure.
  9. Build the formula by combining measures, dimensions, operators, and functions to create the desired metric. Use the “@” symbol to reference existing columns and make sure to validate the formula to prevent errors.
  10. Click on the Validate button to validate the calculated measure.
  11. Click on Add calculated measure to include the calculated measure in your Datasource.