0 Replies Latest reply: Nov 15, 2017 6:00 AM by Lucas Behm RSS

    aggregated averages

    Lucas Behm

      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