rpadminserver
Board Regular
- Joined
- Nov 7, 2007
- Messages
- 111
- Office Version
- 365
Hello ALL...
My Goal: Find the most recent time that a student took a class.
I have a table (called CLASSCOMPLETED) that contains the employreeID, CourseID, CompletedDate.
I need to group by employee id, then group by courseID, then (in descending order of date) rank the classes.
I think RANKX is my solution, but I've not been able to figure out.
Here is an example of what I'm trying to get:
Thanks in advance.
Rob
My Goal: Find the most recent time that a student took a class.
I have a table (called CLASSCOMPLETED) that contains the employreeID, CourseID, CompletedDate.
I need to group by employee id, then group by courseID, then (in descending order of date) rank the classes.
I think RANKX is my solution, but I've not been able to figure out.
Here is an example of what I'm trying to get:
| Employee ID | CourseID | CompletedDate | Ranking |
| rob | c0001 | 7/1/2020 | 1 |
| rob | c0001 | 6/15/2019 | 2 |
| rob | c0002 | 3/12/2021 | 1 |
| rob | c0002 | 9/15/2020 | 2 |
| rob | c0002 | 2/25/2019 | 3 |
Thanks in advance.
Rob
