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
- Login to SAC tenant.
- Open any story
- Create a numeric chart
- Check the aggregation type by default it is sum.
Resolution
The aggregation type can be changed from the builder panel.
- Click on the chart > open the builder panel.
- Click on add measure > click on add calculation
- From the type dropdown select Aggregation.
- From the Operations dropdown you can select any aggregation type such as AVERAGE as required.
- 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