Duplicate Candidate Rows in People Story Recruiting Report

[BrandyPelzel]

I'm building a People Story report to analyze recruiting metrics such as time to hire, time to fill, recruiting time, etc., using various date fields (e.g., requisition created, offer created/approved, application created). Attached is the query design.

When reporting on multi-vacancy requisitions, the table in the report displays candidates in multiple rows. For example, if a requisition has five positions and each is filled by a different candidate, the table lists each candidate for every position—resulting in 25 rows instead of 5 (each candidate appears multiple times).

Each candidate should appear in the report once, associated only with the specific position they have filled.

What could be causing these duplicate entries? How can I adjust my report or data join so that each candidate appears just once, matched to their filled position? 

 

[Olga_Antipina]

I think this is just the way Job Requisition table from Recruting is linked to Position from EC. This kind of situation can sometimes happen also in Performance, LMS, EC Time. Try first to do an Inner join, maybe that help. If not, maybe you can do a filter to filter out irrelevant records (by comparing Position code from JR with Position code from Position with if-function). Otherwise, maybe try to take the position code from JR only and remove position table from this query. Create an additional Query only on Position and link them in the Designer view.