Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to calculate the cumulative time value for the field "CycleTime" in the data given below.
Case Identifier | CycleTime | OverallTime |
{F0F6B873-0000-C41D-BF1D-684552BDE75F} | 0 00:12:41 | 0 08:03:21 |
{F0F6B873-0000-C41D-BF1D-684552BDE75F} | 0 03:23:16 | 0 08:03:21 |
{F0F6B873-0000-C41D-BF1D-684552BDE75F} | 0 04:27:24 | 0 08:03:21 |
{F0CB2672-0000-C71C-950C-4DC2C310315C} | 0 23:04:02 | 5 21:53:37 |
{F0CB2672-0000-C71C-950C-4DC2C310315C} | 4 22:49:35 | 5 21:53:37 |
{F0B4C172-0000-CC1D-838E-E55D99EFAB9A} | 0 00:12:47 | 0 02:20:20 |
{F0B4C172-0000-CC1D-838E-E55D99EFAB9A} | 0 02:07:33 | 0 02:20:20 |
{F0864F72-0000-CC1B-B062-B7293AD99108} | 0 19:33:02 | 7 06:36:01 |
{F0864F72-0000-CC1B-B062-B7293AD99108} | 6 11:02:59 | 7 06:36:01 |
{F076C870-0000-CE87-BB73-11F1FFB2ADF6} | 5 23:43:57 | 13 01:00:46 |
{F076C870-0000-CE87-BB73-11F1FFB2ADF6} | 7 01:16:49 | 13 01:00:46 |
{F076C870-0000-C4D4-B164-AB86D7502138} | 19 06:10:33 | 17 05:46:44 |
{F076C870-0000-C4D4-B164-AB86D7502138} | 26 23:36:11 | 17 05:46:44 |
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D} | 0 02:52:43 | 9 02:27:46 |
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D} | 6 03:21:46 | 9 02:27:46 |
{F04FBE73-0000-CC1C-BBA9-3AC477F4919D} | 2 20:13:17 | 9 02:27:46 |
{F049BE73-0000-CA19-9210-73ED99172400} | 0 00:16:04 | 15 03:45:39 |
{F049BE73-0000-CA19-9210-73ED99172400} | 0 00:17:23 | 15 03:45:39 |
{F049BE73-0000-CA19-9210-73ED99172400} | 6 03:27:03 | 15 03:45:39 |
{F049BE73-0000-CA19-9210-73ED99172400} | 8 23:45:09 | 15 03:45:39 |
{E0FB2574-0000-CC12-8A93-D758F7A4B467} | 0 00:02:05 | 0 00:27:39 |
{E0FB2574-0000-CC12-8A93-D758F7A4B467} | 0 00:25:34 | 0 00:27:39 |
{E076C870-0000-C37F-B5CE-960AC1FFC18B} | 5 19:51:29 | 15 12:47:50 |
{E076C870-0000-C37F-B5CE-960AC1FFC18B} | 9 16:56:21 | 15 12:47:50 |
Here the "Case Identifier" is a repetitive value and "OverallTime" is the sum of all the "CycleTime" belonging to the same
"Case Identifier". Is there any way to calculate the cumulative time for each case ID instead of the overall time.
Please let me know
Thanks,
Varun
Attached example of required output: