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,

To get the Exception Aggregation and Aggregation you will need to highlight on the measures and then ... ( 3 dots ) which will then give you the option and then this can be displayed in the grid.

Good Luck

Afshin

[Former Member]

Thanks for your reply. Somehow it doesn't seem to work, could you please again guide me more specifically.

So I hover the Measures and get the three point icon:

Then clicking it I get the following dropdown:

hen going to "Add Calculation" I end up in the fx editor which then doesn't offer me the "Aggregation" function as shown in my initial post.

Looking forward to your reply.

Thanks and kind regards, Jonas