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,

I suspect you did not click on the measures .. I can see this is done on the dimension Calendar Day.

Cheers

Afshin