How to use Aggregation function in a table

[#1]

Hey,

I am curious about how to use the aggregation function within a table in a story to calculate the average value of a certain measure over time where time acts as dimension.

When I open the fx editor within the measures I don't get the "Aggregation" option in the dropdown. If I open the "Add measure" dropdown I am not able to create a new measure from calculation (other than in this tutorial)

So how to come about it? Note that the option is well available once I switch to a barchart e.g.

[former_member6443]

Hi Jonas,

Click on Add Calculation and you should see something like this,

Suggest Live Models you do in the HANA side

Regards

Afshin

[Former Member]

Hey,

this is where I end up then:

Which is a totally different dialogue and it doesn't offer the "aggregation" function at all.

Kind regards,

Jonas