LMS Story Report - How to report on latest completion date only?

[Isabela_Uribe]

Hi,

I've created an LMS Story Report to output learning completions, however, I am only want to report on the latest completion date of a course.

For example, if an employee has completed the same course 3 times, and those 3 course completions are in their learning history with three different completion dates (first completion date is 01/01/2019, second is 05/31/2020 & last date is 12/31/2022) then I only want my report to output that latest 12/31/2022 completion date for that course.

Currently, my report outputs 3 rows for the same course, each with a different completion date, but I only want 1 row with the latest completion date.

Any help is appreciated!

[vickyjain9181]

Hi, 

Did you figure out a solution for this issue?  I have a similar requirement where I need to find the maximum date from multiple rows.  Please let me know.

Thanks,

Vicky.