aggregated averages

[Anonymous]

Hello,

im trying to make a direct day to day comparison 2106 - 2017 where my only dimensions are MonthNum, DayNum

I have the total number of parcels per day for each year.

I cant get the table to calculate the average number of parcels per day of the week of the respective year.

WekkdayNum 0 as Monday

eg:

MonthNum / DayNum / Weekday2016 / Weekday2017 / avg no of parcels per weekday 2016 / avg no of parcels per weekday 2017

1 / 13 / 2 / 4 / avg no of parcels on weekday 2 in 2016 / avg no of parcels on weekday 4 in 2017

so far I have tried something like below but without results (no calculation)

avg( aggr(count( DISTINCT {1 <Year={'$(=year(today())-1)'}>}%ParcelNumber), Year, WeekdayNum))

attached is the created table with the daily parcel data.

any help is appreciated.

thanks,

Lucas