Forum Discussion
Average min Time for unique categories
Hi,
I have a following data set:
| Job Posting Date | Manager Review Date | Candidate | Req ID |
| 2.03.2022 | 7.03.2022 | Jan Kowalski | A202011 |
| 7.03.2022 | 20.03.2022 | Mark Simith | A202011 |
| 13.04.202 | 21.04.2022 | Anna Pain | A202011 |
| 15.04.2022 | 18.04.2022 | Rob Kowalsky | A181030 |
| 22.05.2022 | 26.05.2022 | Mateusz Lubczyk | A340923 |
| 2.06.2022 | 5.06.2022 | Jin Xio | A340923 |
Now, I need to calculate Average Time to Shortlist (Time to Shortlist = time from Job Posting to submission of the first candidate per Req ID to the Manager Review).
I was able to calculate average time from job posting to manager review for all cadidates but I don't know how to do it only for the first candidate per unique job ID.
I would appreaciate your advise 🙂
Hi KLKasia,
Did the above suggestion help with your scenario? if that is the case, you can consider Kudo or accept it to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
2 Replies
CNENFRNLCommunity Champion
Hi KLKasia,
Did the above suggestion help with your scenario? if that is the case, you can consider Kudo or accept it to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng