Calculate weekly average of column in Webi

Question

I have a table with 3 columns in SAP Webi as shown in the picture.

In column "weekly average" I want to dynamically calculate the weekly average (from Monday to Sunday) of column "count".

Is it possible to do it with a variable? If not, any suggestions how to do it with other methods?

Thanks.

Answer 1

Yes, this can be done. Two steps: first create a variable to define a single value for each week, then another to return the average of those values.

For step 1, create a new variable ("Date Week") with the following definition:

=LastDayOfWeek([Date])

Then, in the report block (where your "Weekly Average" column is), create this formula:

=Average([Count]) in ([Date Week])

This should produce the result you want.