Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
BI Reporting Display only max date for user — 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

BI Reporting Display only max date for user

Question
16
Views
0
Comments
edited Jan 3, 2019 6:05PM in Taleo Learn

Summary

Need course completion report to show only 1 record per user (most recent)

Content

Course completion report: Currently filtered to show only the last 1 year of records. Also, need it to only show the most recent completion for each user. Since this is part of a learning plan users get a reminder 30 days in advance and so most have 2 records in the past year. 

I can't use the learning plan report because after the 30-day renewal the users last completion date gets cleared from the learning plan report even though they still have another 30 days of compliance. 

The plan is for this report to be run daily and the file will be transferred automatically thus the need for this report to be filtered when it's run.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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