Solved
Filter the task with the MAX Go Live date for each project
I have four task bundles, and I want to filter out the task with the maximum date for each project. Any suggestions on how to achieve this?
Task bundles (each project has got multiple Go Lives)
| Task | Project | Go Live Date |
| Task A | Project 1 | 01-Jan-2023 |
| Task B | Project 1 | 01-Feb-2023 |
| Task C | Project 2 | 01-Mar-2023 |
| Task D | Project 2 | 01-Apr-2023 |
Expected Output:
| Task | Project | Go Live Date |
| Task B | Project 1 | 01-Feb-2023 |
| Task D | Project 2 | 01-Apr-2023 |
My approach:
1) Apply dateDifference(Go Live Date;now)
2) The task with MAX date will have max date difference
3) Now I either need to numeric aggregate with project grouping to get MAX dateDifference record or somehow filter out unnecessary records. Need suggestion on how to proceed from here.