SAP Knowledge Base Article - Public

3584757 - Aggregation type shows as default in stories in SAP Analytics Cloud (SAC)

Symptom

Specify/Change type of aggregation as average in numeric chart instead of the default sum without using the exception aggregation in the model.

Environment

SAP ANALYTICS CLOUD 2025.1.6 

Reproducing the Issue

 

  1. Login to SAC tenant.
  2. Open any story
  3. Create a numeric chart
  4. Check the aggregation type by default it is sum.

 

Resolution

The aggregation type can be changed from the builder panel.

  1. Click on the chart > open the builder panel.
  2. Click on add measure > click on add calculation
  3. From the type dropdown select Aggregation.
  4. From the Operations dropdown you can select any aggregation type such as AVERAGE as required.
  5. Select the measure and the aggregation dimension and then click on ok.




See Also

Keywords

SAC, SAP Analytics Cloud, aggregation, story, builder panel , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0