Forum Discussion
Date on Date comparison on record statuses
Community SupportHi mhorn30 ,
I'm confused about your requirement. You want to compare the number of applicants per status between a date last year vs. this year. Moreover, you need to based on the selected date and different status per candidate, right? I can't understand why show the Candidate ID 201 in green when you choose "01 September"? Are the 101 and the 201 the same candidate? Can you please share more details for us?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Candidate 201 "Applicant" status is green as this is the latest status update for that candidate on or before 01 September.
The next status for Candidate 201 is "Completed" which was only set on the 02 September. So if I compare YoY according to a specific date (01 Sept in this case), this status has not happened yet.
Candidate ID's are unique, so 101 and 201 is not the same user.
If I was to select 01 October as my comparison data YoY, then these would be the statusses per candidate that was returned as they are the latest status on or before 01 October.
| Programme | Candidate ID | Status | Date |
| 2019 Programme | 101 | Applicant | 26/08/2018 |
| 2019 Programme | 101 | Completed | 29/08/2018 |
| 2019 Programme | 101 | Reviewed | 01/09/2018 |
| 2019 Programme | 102 | Applicant | 05/09/2018 |
| 2020 Programme | 202 | Applicant | 29/09/2019 |
| 2020 Programme | 202 | Completed | 01/10/2019 |
| 2020 Programme | 201 | Applicant | 28/08/2019 |
| 2020 Programme | 201 | Completed | 02/09/2019 |
| 2020 Programme | 201 | Reviewed | 05/09/2019 |
| 2020 Programme | 201 | Accepted | 10/09/2019 |
If I was to select 29 August, then only these statusses per candidate will be returned:
| Programme | Candidate ID | Status | Date |
| 2019 Programme | 101 | Applicant | 26/08/2018 |
| 2019 Programme | 101 | Completed | 29/08/2018 |
| 2019 Programme | 101 | Reviewed | 01/09/2018 |
| 2019 Programme | 102 | Applicant | 05/09/2018 |
| 2020 Programme | 202 | Applicant | 29/09/2019 |
| 2020 Programme | 202 | Completed | 01/10/2019 |
| 2020 Programme | 201 | Applicant | 28/08/2019 |
| 2020 Programme | 201 | Completed | 02/09/2019 |
| 2020 Programme | 201 | Reviewed | 05/09/2019 |
| 2020 Programme | 201 | Accepted | 10/09/2019 |