Skip to main content

Aggregation for Measures

Overview​

In Datafor, measures are calculations used for dynamic data analysis. Setting the correct aggregation method is essential for accurate data representation and analysis.

Types of Aggregation Methods​

Datafor supports various aggregation methods, including:

  • Sum: Adds all the values.
  • Average: Calculates the mean of the values.
  • Minimum (Min): Finds the smallest value.
  • Maximum (Max): Finds the largest value.
  • Count: Counts the number of values.
  • Distinct Count: Counts the number of unique values.

Setting Aggregation type for Measures​

Setting in the Analysis Model​

The default aggregation type for measures in the analysis model is "Sum".

  1. Select the measure in the analysis type that you want to modify.
  2. In the properties panel, find the "Aggregation type" option and change the aggregation type as needed.
  3. After setting, save the model.

1681545207022

Setting Aggregation type in Reports​

To set aggregation methods while creating reports:

  1. In the report edit view, find the measure field.
  2. Open the context menu for the measure field.
  3. Select the "Aggregation" menu.
  4. Choose the desired aggregation method from the submenu to switch the measure's aggregation type.

1681545142302