Andreas Karagiannis Posted November 26, 2019 Share Posted November 26, 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. Step 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 Link to comment Share on other sites More sharing options...
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