BI Reporting Display only max date for user
SummaryNeed course completion report to show only 1 record per user (most recent)
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.