Learning Report to show the most recent record

Mark MacFarlane

I have a request to provide a report that lists the employees and only the most current record of course completion status. Example: employee 1 has four records for course X the most recent record at the course / offering level is in progress. When a run a report today I will get four rows for employee 1

JohnW-Oracle

HI @Mark MacFarlane,

FDI's Oracle Analytics Cloud can use MAX functions as suggested by Bhaskar and then you can combine those with the use of Filters as described here:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/filters.html#GUID-8B78EB53-F615-4B35-9A06-0AF63376B7CF

If this question is specific to OTBI, there is another community here:

https://community.oracle.com/products/oracleanalytics/categories/otbi

Regards,

John

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24583/learning-report-to-show-the-most-recent-record

Hi @Mark MacFarlane,

Have you tried using 'MAX BY'?

Please take a look into the following post which might be useful.

How to report on training with active reassignment rules & multiple records per employee? — Cloud Customer Connect

Hope this help.

Cheers,

Bhaskar Konar

Hi @Mark MacFarlane,

Please find below another good example.

How to use MAX Date in OTBI — Cloud Customer Connect

Hope this help.

Cheers,

Mark MacFarlane

Hi @Bhaskar Konar,

The MAX function works, thank you !!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63811#Comment_63811

Hi @Mark MacFarlane,

Glad to hear that.

Can you please select the answer that help you to resolve the issue, it'll be helpful for fellow community members in future.

Thank You!

Cheers,