Pull Max Effective Row for Associates — Cloud Customer Connect
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

Pull Max Effective Row for Associates

edited Nov 4, 2016 6:17PM in Reporting and Analytics for HCM 7 comments

Summary

Return only the most current row for a list of active and terminated associates

Content

I'm trying to build a report to pull the most current data for a list of associates. When i use the MAX aggregate it gives me the max data per department and not just the most recent row of data, which is what i want to see. I'm building this off of the Worker Assignment Event Real Time subject area. Should i be using a different subject area or is there a different way that i can create this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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