OTBI - Work Relationship Start Date
SummaryTrying to return a single line per employee instead of all dates of job change.
The work relationship start date returns a row of data for employees for each job change. I.e. I was hired as an account exec 1/1/2020 and became a sr account exec on 1/1/2021. There would be a row of data for each. I am trying to figure out how I can filter it to only return the most recent entry so that each employee has a single line of data that shows their current job and when they started.
Still pretty new to OTBI so I am kind of feeling around in the dark a bit.