Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to Sum or Avg same date field but previous step (Action_date)
So i can now how much days it takes between tasks
this is how table looks:
Count -No. -ACTION_DATE -Task
1 | 995098 | 20-07-09 12:11 | New_Application |
1 | 995098 | 02-08-09 8:59 | New_Application |
1 | 995098 | 02-08-09 13:01 | New_Application |
1 | 995287 | 13-08-09 10:21 | New_Application |
1 | 995287 | 18-08-09 12:58 | New_Application |
1 | 995287 | 18-08-09 13:25 | New_Application |
1 | 995287 | 18-08-09 13:36 | New_Application |
1 | 995287 | 18-08-09 13:38 | New_Application |
1 | 995287 | 25-10-09 12:10 | New_Application |
1 | 995287 | 25-10-09 12:10 | New_Application |
1 | 1001675 | 06-11-13 12:15 | New_Application |
1 | 1001675 | 24-12-13 7:13 | New_Application |
1 | 1001675 | 24-12-13 7:21 | New_Application |
1 | 1001675 | 24-12-13 7:21 | New_Application |
1 | 1001675 | 24-12-13 7:21 | New_Application |
2 | 1025913 | 21-05-20 16:26 | New |
1 | 995287 | 13-06-20 18:05 | Update |
1 | 995287 | 14-06-20 0:17 | UpdateRequest |
1 | 995287 | 14-06-20 8:42 | Social |
1 | 995287 | 14-06-20 14:56 | Approval |
1 | 995287 | 15-06-20 1:47 | Approval |
1 | 995287 | 02-07-20 12:01 | Committe |
1 | 995287 | 02-07-20 12:03 | Committee |
1 | 995098 | 09-11-20 9:25 | Approval |
1 | 995098 | 09-11-20 12:32 | Approval |
1 | 995098 | 25-11-20 11:10 | Committee |
1 | 995098 | 25-11-20 12:24 | Council |
expected output:
Count - No. - ACTION_DATE - expected outcome - Task
1 | 995098 | 20-07-09 12:11 | 0.00 | New_Application |
1 | 995098 | 02-08-09 8:59 | 0.00 | New_Application |
1 | 995098 | 02-08-09 13:01 | 0.00 | New_Application |
1 | 995287 | 13-08-09 10:21 | 11.00 | New_Application |
1 | 995287 | 18-08-09 12:58 | 5.00 | New_Application |
1 | 995287 | 18-08-09 13:25 | 0.00 | New_Application |
1 | 995287 | 18-08-09 13:36 | 0.00 | New_Application |
1 | 995287 | 18-08-09 13:38 | 0.00 | New_Application |
1 | 995287 | 25-10-09 12:10 | 7.00 | New_Application |
1 | 995287 | 25-10-09 12:10 | 0.00 | New_Application |
1 | 1001675 | 06-11-13 12:15 | 0.00 | New_Application |
1 | 1001675 | 24-12-13 7:13 | 30.00 | New_Application |
1 | 1001675 | 24-12-13 7:21 | 0.00 | New_Application |
1 | 1001675 | 24-12-13 7:21 | 0.00 | New_Application |
1 | 1001675 | 24-12-13 7:21 | 0.00 | New_Application |
2 | 1025913 | 21-05-20 16:26 | 0.00 | New |
1 | 995287 | 13-06-20 18:05 | Update | |
1 | 995287 | 14-06-20 0:17 | UpdateRequest | |
1 | 995287 | 14-06-20 8:42 | Social | |
1 | 995287 | 14-06-20 14:56 | Approval | |
1 | 995287 | 15-06-20 1:47 | Approval | |
1 | 995287 | 02-07-20 12:01 | Committe | |
1 | 995287 | 02-07-20 12:03 | Committee | |
1 | 995098 | 09-11-20 9:25 | Approval | |
1 | 995098 | 09-11-20 12:32 | Approval | |
1 | 995098 | 25-11-20 11:10 | Committee | |
1 | 995098 | 25-11-20 12:24 | Council |
What are you expecing as outcome?
Sum of days between tasks based on action_date
Output please?
I added to main post
thanks
Will you able to share more data than 2-5 records? It would be easy to handle if you have different tasks and expected output?
Updated please check
Sorry, If i am asking too many questions, But I still not understanding your requirement? Why 1st count is Zero since it is counting the value of 2nd step? Can you please explain the logic behind. also confirm where you need script or design?