Forum Discussion
Solved
Group by
Hi everyone, I am struggling with grouping the below set of data: 1) Firstly, I want to group the highlited columns. My final result should be: one row with date and total amounts for both colum...
Hi Ankit,
Sample data:
| Last date of the week | Incoming | Shipment | Backlog |
| 12/25/22 | 0 | 1291.03 | 25237 |
| 12/25/22 | 0 | 0 | 25237 |
| 12/25/22 | null | null | null |
| 12/25/22 | 0 | 0 | 25237 |
| 12/25/22 | 0 | 14573.53 | 26528 |
| 12/25/22 | 0 | 0 | 31143 |
Expected:
| Last date of the week | Incoming | Shipment | Backlog |
| 12/25/22 | 0 | 15864.56 | 31143 |
Thank you!
Hi Ankit,
Thanks! There is one issue with backlog value - it will not be always max value.
Please find below the example:
Last date of the week Incoming Shipment Backlog 12/18/22 5036.31 0 31782 12/18/22 0 0 31143 12/18/22 0 1988.02 31143 12/18/22 0 0 26746 12/18/22 0 0 26746 Expected:
Last date of the week Incoming Shipment Backlog 12/18/22 5036.31 1988.02 26746 Hi alice25
Not possible with group by as we can choose either max, min, sum, avg, count etc with the group by.