For more information, please refer to this announcement explaining best practices for getting answers to questions.
Step/Status Dates for Single Job Submission in One Line in Report
Content
We are still on BOXI R2, and I am working on a report to include the dates for particular steps and statuses that a candidate was moved through on a single job submission in a single line in the report; however, I am struggling with how to get the correct date in each field without getting #MULTIVALUE or #ERROR. I have tried a couple of different ways, once with a single query and once with a separate query for each individual step/status, but in both scenarios, I have ran into issues.
I have attached a screen shot of how we would like the fields in the report to be laid out, as well as, the query and filter structure as it is currently. Has anyone else created a similar type of report that might be able to provide me with some feedback on the best way to accomplish this?