OTBI report for learner count, count of learner according to number of courses completed — 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

OTBI report for learner count, count of learner according to number of courses completed

in Reporting and Analytics for HCM

Summary:

I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need to fetch the total number of learners in the respective month.

I am creating a OTBI report for that.

I have created a logical SQL for that but thats not working

Can you please help in the logical SQL.

Please guide what I need to do.

Content (please ensure you mask any confidential information):

SELECT sum (B.saw_1),B.saw_2
FROM (
SELECT count (A.Person_Number) saw_1,A.Completion_Date saw_2,A.Course_Count saw_3

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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