I have a data set of workflow approval, showing an approval step by certain individuals, and wanting to calculate the total time for approval of a workflow and the total times in which the workflow is held within a status:
Things I want to calculate:
- Workflow time spent in each status
- Value change within each status step change
| Workflow | Promo Start | Promo end | Status | Cost | Workflow Change Step |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 1 | 50,000.00 | 28/02/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 2 | 50,000.00 | 01/03/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 3 | 50,000.00 | 02/03/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 4 | 50,000.00 | 25/04/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 5 | 50,000.00 | 25/04/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 6 | 75,000.00 | 26/04/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 7 | 75,000.00 | 15/05/2023 |
| Workflow 1 | 01/03/2023 | 31/12/2023 | Step 8 | 75,000.00 | 22/05/2023 |
| Workflow 2 | 01/03/2023 | 31/12/2023 | Step 1 | 25,000.00 | 25/04/2023 |
| Workflow 2 | 01/03/2023 | 31/12/2023 | Step 2 | 50,000.00 | 26/04/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 1 | 90,000.00 | 25/04/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 2 | 90,000.00 | 25/04/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 3 | 120,000.00 | 26/04/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 4 | 120,000.00 | 15/05/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 5 | 120,000.00 | 22/05/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 6 | 120,000.00 | 13/10/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 7 | 120,000.00 | 13/10/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 8 | 120,000.00 | 16/10/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 9 | 120,000.00 | 18/10/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 10 | 150,000.00 | 03/11/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 11 | 150,000.00 | 06/11/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 12 | 150,000.00 | 07/11/2023 |
| Workflow 3 | 01/01/2023 | 31/12/2023 | Step 13 | 150,000.00 | 09/11/2023 |
