Average min Time for unique categories

[KLKasia]

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 🙂 

[CNENFRNL · Accepted solution]

[v-shex-msft · Accepted solution]

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

[CNENFRNL · Accepted solution]