Calculated Measures (SAC- SAP Analytics cloud)

Lets take an existing dashboard and create calculated measures for it

Let's take a duplicate of the existing chart.

Create Calculation.

These are the options available in Calculation editor.

Calculated Measure

Formulas can be typed in directly and include various mathematical operations and functions. The calculation editor automatically recognizes some inputs and offers visual help to accelerate the formula creation and support you in selecting measures and functions.

On the right side, all available functions, operators, and conditions can be accessed directly.

We also have an Assistant to prompt us while typing in the editor.

Restricted Measure

Allows you to restrict a measure based on one or multiple dimensions. Dimension members can be either pre-selected or dynamically chosen by an input control while in view mode.

Difference From

If you want to calculate how a measure deviates over time, you can use this option

Aggregation

The aggregation calculation provides various aggregation options for measures.

example- sum, count, max, min, average, first, last...

Dimension to Measure

Sometimes a measure is erroneously created as a dimension, or a dimension contains only numeric values. In this case, the Dimension to Measure option can be used to convert dimensions to measures.

In our case, let's do an aggregation of average sales per region.