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.

[Ashok_R]

Hi Jonas,

which is the datasource are you trying to access here?

Regards,

Ashok R

[Former Member]

Hey Ashok,

the table is linked to a model which itself queries the data via a live connection from CB1/BW.

Regards,

Jonas