When I add a base measure with average aggregation, the Total field should show the average value. But why is it showing the sum of that average?

• Related Articles

• While adding a base measure with average aggregation then, the total field should show the average value, but it shows the sum of that average. Why?

  Whenever the aggregate functions are applied, it will consider only the line items but not the TOTAL column. Total field always displays the summed-up values from the line items.

• Expression measure created shows the sum of all data displayed. It is expected to show based on the expression specified

  The Total row of an expression measure will provide the summation of all the rows whereas, computed measure will provide results based on the formula specified. This is the standard ARC functionality.

• Does the Expression Measure display the sum of all the data or data based on the expression specified?

  Expression Measure displays the sum of all the data. The Total Row of an Expression Measure displays the sum of all the rows. The Computed Measure for a KPI displays the data based on the expression specified. This is a standard ARC functionality.

• Store Scorecard KPI: Queries why there are no Available Base Measures to add

  When we select 'Add base measure', the list of base measures apart from whatever is used in the KPI (for the specific combination of dimensions used) will get listed under 'Available base measures' pane. For Store Scorecard KPI, since there are no ...

• I cannot view any Available Base Measures to add to a KPI. Why?

  When we select 'Add Base Measure', the list of base measures used in the KPI gets listed under 'Available Base Measures' pane. The pane will be blank when it has no combination of dimensions used in the KPI. This is the functionality of ARC.