Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get the latest completion date along with the new due date? (Learning Assignment)

Received Response
61
Views
1
Comments
Kobe Chavez
Kobe Chavez Rank 1 - Community Starter

Summary:

We want to get in the report the latest completion date of the learner and the new due date in each course in 1 row for each learner. However, we are getting 2 rows. Is our requirement possible? Please check the attached screenshot and the SQL we created.

Below is the SQL used.

Thank you!

Answers