aggregate data over year and week

gustavofred — Wed, 10 Mar 2021 07:52:33 GMT

I want to aggregate data for value a and b over the year-week (or week AND year) and divide.

somehow my approach is not working, what am i doing wrong? im getting "-" as result.

Aggr({1}sum([value a]),year, week )/Aggr({1}sum([value b]),year, week)

my dimensions are year, week, location, year-week currently. Im using a diagram object as a table.

Re: aggregate data over year and week

edwin — Wed, 10 Mar 2021 18:01:55 GMT

try

=sum(value_a)/sum(total <year> value_a)