workflow
1 Topic
Status & Workflow Processing Time
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/2023Solved679Views0likes2Comments