Using aggregate with Sum measure and for each employee doesn't work

alespooletto — Tue, 05 Mar 2024 12:49:16 GMT

I am trying to get an average sum of hours worked for each employee across all dates in a dashboard. This is only for 2024, but when I show it it gives me an average of 307.

THe formula I am using

```

AvG(Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'}, Employee=>} Sum(Duration), Date))

```

Can anybody help me work this out?

Re: Using aggregate with Sum measure and for each employee doesn't work

Antoine04 — Tue, 05 Mar 2024 12:51:21 GMT

Hello what about that ?

- AvG(Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'}, Employee=>} Sum(Duration), Date, Employee))

Regards

topic Using aggregate with Sum measure and for each employee doesn't work in App Development

Using aggregate with Sum measure and for each employee doesn't work

Re: Using aggregate with Sum measure and for each employee doesn't work