You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Returning only one row when the person ID is duplicated

Received Response
36
Views
4
Comments
edited Dec 28, 2016 8:05PM in Reporting and Analytics Taleo Enterprise 4 comments

Summary

If a Person ID is on 2 rows, can one of those rows be eliminated from the results based a different field?

Content

Hello,

If a candidate (Person ID) is listed on 2 or more rows, can the results only show me 1 row based on the earliest date in a different field (Assessment Sent)?

The example picture shows how I would only want the row for Person ID 1623190 with the earliest Assessment Sent date and not the row with a score of 0, but I would still need to keep the row for Person ID 1623830 because I need to know that the assessment was sent but not taken. This means I can't just filter out all of the 0 Assessment Scores. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!