Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My data :
Case Identifier | Cycle | Stage | Max stages in the cycle | Overall Status | Time (Days and Hours) | SLA Time Scale | SLA.Time |
{E075B973-0000-C511-B2FA-0428B188370D} | 6 | 2 | 5 | Pending | 0 00:20:21 | Less Than 7 Days | 12/05/2021 10:06:20 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 6 | 1 | 5 | Pending | 0 | Less Than 7 Days | 12/05/2021 10:05:59 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 5 | 2 | 2 | Complete | 0 00:15:18 | Less Than 7 Days | 21/10/2020 10:21:15 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 5 | 1 | 2 | Pending | 0 | Less Than 7 Days | 21/10/2020 10:05:57 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 4 | 2 | 2 | Complete | 0 00:07:21 | Less Than 7 Days | 20/10/2020 2:58:41 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 4 | 1 | 2 | Pending | 0 | Less Than 7 Days | 20/10/2020 2:51:20 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 3 | 2 | 2 | Complete | 0 03:22:03 | Less Than 7 Days | 20/10/2020 2:37:09 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 3 | 1 | 2 | Pending | 0 | Less Than 7 Days | 20/10/2020 11:15:06 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 2 | 2 | 2 | Complete | 0 00:46:35 | Less Than 7 Days | 05/08/2020 11:28:05 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 2 | 1 | 2 | Pending | 0 | Less Than 7 Days | 05/08/2020 10:41:30 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 1 | 2 | 2 | Complete | 0 04:24:59 | Less Than 7 Days | 04/08/2020 10:38:39 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 1 | 1 | 2 | Pending | 0 | Less Than 7 Days | 04/08/2020 6:13:40 PM |
{1234B} | 2 | 2 | 3 | Pending | 0 00:46:35 | Less Than 7 Days | 05/08/2020 11:28:05 AM |
{1234B} | 2 | 1 | 2 | Pending | 0 | Less Than 7 Days | 05/08/2020 10:41:30 AM |
{1234B} | 1 | 2 | 2 | Complete | 0 04:24:59 | Less Than 7 Days | 04/08/2020 10:38:39 PM |
{1234B} | 1 | 1 | 2 | Pending | 0 | Less Than 7 Days | 04/08/2020 6:13:40 PM |
What I require now is show only the pending status of the latest cycle in of 'Case ID'. The output required is as shown below:As you can see in the above data when the 'Stage' = 'Max stage in cycle 'the 'Status' is complete.
Case Identifier | Cycle | Stage | Max stages in the cycle | Overall Status | Time (Days and Hours) | SLA Time Scale | SLA.Time |
{E075B973-0000-C511-B2FA-0428B188370D} | 6 | 2 | 5 | Pending | 0 00:20:21 | Less Than 7 Days | 12/05/2021 10:06:20 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 6 | 1 | 5 | Pending | 0 | Less Than 7 Days | 12/05/2021 10:05:59 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 5 | 2 | 2 | Complete | 0 00:15:18 | Less Than 7 Days | 21/10/2020 10:21:15 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 4 | 2 | 2 | Complete | 0 00:07:21 | Less Than 7 Days | 20/10/2020 2:58:41 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 3 | 2 | 2 | Complete | 0 03:22:03 | Less Than 7 Days | 20/10/2020 2:37:09 PM |
{E075B973-0000-C511-B2FA-0428B188370D} | 2 | 2 | 2 | Complete | 0 00:46:35 | Less Than 7 Days | 05/08/2020 11:28:05 AM |
{E075B973-0000-C511-B2FA-0428B188370D} | 1 | 2 | 2 | Complete | 0 04:24:59 | Less Than 7 Days | 04/08/2020 10:38:39 PM |
{1234B} | 2 | 2 | 3 | Pending | 0 00:46:35 | Less Than 7 Days | 05/08/2020 11:28:05 AM |
{1234B} | 2 | 1 | 2 | Pending | 0 | Less Than 7 Days | 05/08/2020 10:41:30 AM |
{1234B} | 1 | 2 | 2 | Complete | 0 04:24:59 | Less Than 7 Days | 04/08/2020 10:38:39 PM |
Please advice how this can be achieved,
Thanks in advance