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