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.

Configure Calculated Measures

1. Click on the icon or the Add 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.

Note

• You can now utilize the calculated measures for detailed Infoboard visualizations.
• The configured calculated measures will be available under Measures, when configuring a widget.

Here’s a breakdown of each part of the formula

1. [Product Name].[Product Name]
   • This part indicates the dimension column. A dimension column contains categorical data that is used to segment or filter the data.
   • In this case, [Product Name].[Product Name] refers to the dimension that holds product names.
2. [Oats]
   • This indicates the specific dimension value within the [Product Name].[Product Name] dimension.
   • Here, [Oats] specifies that the calculation should focus on the product named “Oats”.
3. [Measures].[Profit]
   • This part refers to the measure column. A measure column contains quantitative data that can be aggregated, such as sum, average, or profit.
   • In this formula, [Measures].[Profit] refers to the measure that represents profit.

Note

The formula ([Product Name].[Product Name].[Oats], [Measures].[Profit]) calculates the profit specifically for the product “Oats.” It calculates profit rows where the product name is “Oats”.