Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Got a problem. I'm counting days between two dates, I need to count how many network days are between the lowest date and the second to the lowest, grouped by ID.
The example:
ID | Company name | Process | Send date |
2415976 | JMA | SENT | 2020.06.11 |
2415976 | LD | NOT | 2020.06.11 |
2415976 | JMA | SENT | 2020.07.09 |
2415976 | LD | NOT | 2020.07.09 |
2415976 | JMA | SENT | 2020.07.10 |
2415976 | LD | DONE | 2020.07.10 |
My measure expression looks like this:
avg(networkdays(aggr(min([Send date]),[ID]),aggr(min([Send date],2),[ID])))
Now, somehow it skips the second date, which is equal to the 1st one '2020.06.11', and brings the result 21, which is between '2020.07.09' and '2020.06.11'
The outcome should look like this:
ID | NetWorkDaysBetween |
2415976 | 0 |
Thanks for the help!
Never knew you can accept several answers as solution 🙂