topic Re: Aggregation on full weeks using individual Date field in App Development

Aggregation on full weeks using individual Date field

SDT — Mon, 17 Jun 2024 19:47:11 GMT

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

Re: Aggregation on full weeks using individual Date field

SDT — Mon, 17 Jun 2024 20:34:33 GMT

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

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

Re: Aggregation on full weeks using individual Date field

marcus_sommer — Tue, 18 Jun 2024 11:10:58 GMT

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.