Forum Discussion
Helper IVcalculate duration
Hi alevandenes ,
Assuming the id column corresponds to the order of timestamps, you first need to calculate the start of each stop time where teamMember is equal to the current row teamMember and [id] is < the current row [id] and deduct that from stop. You can then sum the result of a calculated column and show it in a visual.
Pleasae see attached pbix for details.
Super UserHi alevandenes ,
Can you please post your sample data as a text that anyone can copy paste as a table in Exel and not an image? Also to confirm, the duration is ids 5-4, 6-5 etc ?
Helper IV| id | entryType | timeStamp | teamMember |
| 4 | Start | 2023-10-16 13:19:45.628 | 12382 |
| 5 | Stop | 2023-10-16 13:21:10.793 | 12382 |
| 6 | Start | 2023-10-16 13:21:40.157 | 12382 |
| 7 | Stop | 2023-10-16 13:21:44.88 | 12382 |
| 8 | Start | 2023-10-16 13:22:28.313 | 16230 |
| 9 | Stop | 2023-10-16 13:23:24.242 | 16230 |
| 10 | Start | 2023-10-16 13:24:27.739 | 12073 |
| 11 | Start | 2023-10-16 13:26:05.893 | 16230 |
| 12 | Stop | 2023-10-16 13:26:23.473 | 12073 |
| 13 | Start | 2023-10-16 13:28:49.522 | 12382 |
| 14 | Stop | 2023-10-16 13:29:36.053 | 12382 |
| 15 | Start | 2023-10-16 13:29:48.392 | 12382 |
| 16 | Start | 2023-10-16 13:30:00.596 | 12382 |
| 17 | Stop | 2023-10-16 13:30:12.309 | 12382 |
| 18 | Start | 2023-10-16 13:30:16.384 | 12382 |
| 19 | Stop | 2023-10-16 13:30:57.837 | 12382 |
| 20 | Start | 2023-10-16 13:31:17.914 | 12382 |
- danextian
Hi alevandenes ,
Assuming the id column corresponds to the order of timestamps, you first need to calculate the start of each stop time where teamMember is equal to the current row teamMember and [id] is < the current row [id] and deduct that from stop. You can then sum the result of a calculated column and show it in a visual.
Pleasae see attached pbix for details.
- alevandenes
amazing! thanks a lot!