Aggregation on full weeks using individual Date field

[SDT]

Hello,

I have a line chart in an application with two dimensions.

1) IF(Date<Today(0),Date(Weekend(Date),'YYYY-MM-DD'))

2) LostHoursType

The lines are SUM(LostHours)

I am trying to add a reference line for the average.

AVG(AGGR(SUM(LostHours),WeekEnd(Date)))

Does not work.

AVG(AGGR(SUM(LostHours),Date))

Gives me the average for a single Date.

How can I aggregate on a week worth of data?

Thank you

[SDT]

It is not exactly correct, but I ended up implementing this for now:

AVG(AGGR(SUM(LostHours),Date))*7

[marcus_sommer · Accepted solution]

Advanced aggregations with aggr() or TOTAL require native fields and not calculated dimensions. Therefore just replace this calculation with an appropriate field from the calendar.