Andreas Karagiannis Posted November 25, 2019 Posted November 25, 2019 Currently trying to create a group rank based on Dates and Step_ID. If I sort by "asc" the dates column I get something like this and I want to create a rank similer to what I have below tep ID (SFC) ACTION_CODE DATE_TIME_LCL Rank 10 START 07/16/2019 9:25 1 10 COMPLETE 07/16/2019 9:26 1 20 START 07/17/2019 15:46 2 20 COMPLETE 07/17/2019 16:04 2 30 START 07/17/2019 21:23 3 30 START 07/17/2019 22:44 3 30 COMPLETE 07/18/2019 1:27 3 40 START 07/19/2019 3:51 4 40 START 07/20/2019 7:36 4 40 COMPLETE 07/20/2019 8:40 4 50 START 07/21/2019 23:12 5 50 START 07/22/2019 2:37 5 50 START 07/22/2019 5:09 5 50 COMPLETE 07/22/2019 5:49 5 60 START 07/22/2019 6:06 6 60 COMPLETE 07/22/2019 6:08 6 70 START 07/22/2019 11:04 7 70 START 07/22/2019 18:25 7 70 COMPLETE 07/24/2019 7:50 7 80 START 07/24/2019 14:38 8 80 COMPLETE 07/24/2019 14:48 8 90 START 07/29/2019 10:44 9 90 COMPLETE 07/29/2019 10:45 9 100 START 07/29/2019 10:46 10 100 COMPLETE 07/29/2019 10:46 10 110 START 07/29/2019 10:46 11 110 COMPLETE 07/29/2019 10:47 11 120 START 07/29/2019 10:47 12 120 COMPLETE 07/29/2019 10:47 12 130 START 07/29/2019 10:48 13 130 COMPLETE 07/29/2019 10:48 13 140 START 07/29/2019 14:58 14 140 COMPLETE 07/29/2019 16:17 14 150 START 07/29/2019 16:18 15 150 COMPLETE 07/29/2019 16:22 15 160 START 08/06/2019 13:29 16 160 COMPLETE 08/06/2019 13:47 16 170 START 08/06/2019 13:52 17 170 COMPLETE 08/06/2019 14:07 17 180 START 08/19/2019 15:24 18 180 START 08/19/2019 18:49 18 180 START 08/20/2019 0:20 18 180 COMPLETE 08/20/2019 0:21 18 190 START 08/20/2019 0:23 19 190 COMPLETE 08/20/2019 0:25 19 200 START 08/20/2019 6:40 20 200 START 08/28/2019 7:43 20 200 START 08/29/2019 14:32 20 200 START 08/30/2019 6:43 20 200 START 08/30/2019 12:13 20 10 START 09/04/2019 16:12 21 10 COMPLETE 09/04/2019 17:29 21 200 START 09/05/2019 14:24 22 200 START 09/07/2019 15:21 22 200 START 09/07/2019 20:58 22 200 START 09/08/2019 12:21 22 200 START 09/11/2019 14:17 22 200 START 09/11/2019 19:49 22 200 START 09/18/2019 23:06 22 200 START 09/20/2019 16:28 22 200 START 09/24/2019 3:41 22 10 START 09/25/2019 22:49 23 10 COMPLETE 09/26/2019 5:01 23 200 START 09/26/2019 6:23 24 200 START 09/26/2019 12:34 24 200 START 09/26/2019 22:57 24 191 START 10/04/2019 0:09 25 191 START 10/07/2019 6:48 25 191 START 10/07/2019 19:27 25 191 COMPLETE 10/08/2019 0:41 25 200 START 10/08/2019 22:57 26 200 START 10/09/2019 2:07 26 10 START 10/09/2019 13:58 27 10 START 10/10/2019 5:00 27 10 COMPLETE 10/10/2019 5:52 27 200 START 10/10/2019 22:51 28 200 START 10/11/2019 5:28 28 10 START 10/11/2019 16:47 29 10 COMPLETE 10/11/2019 16:54 29 200 START 10/19/2019 20:11 30 200 START 10/19/2019 21:20 30 200 START 10/20/2019 22:24 30 200 START 10/21/2019 3:56 30 200 START 10/22/2019 13:16 30 200 COMPLETE 10/22/2019 13:16 30
Khushboo Rabadia Posted November 27, 2019 Posted November 27, 2019 Hello, Can you please complete the description, it seems to be incomplete. What is the expected outcome.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now