M2: DISCOVERY Add information about number of courses in a program to the aggregate report.

Description

  • In order to support the majority of columns in the aggregate report (e.g. "Learners in 1+ Courses in <Track>...Learners in N Courses in <Track> and "Learners Completed 1+ Courses...Learners Completed N Courses", we need information about the number of courses in the program.

  • Potential options:

    • Add this information to each row in the individual learner report table. This duplicates the information unnecessarily but is probably the easiest path forward.

    • Create a second table under the programs_reporting schema that contains information about the number of courses in a program. There's some uncertainty about how to access this data in a the analytics pipeline job.

    • Export the appropriate course_discovery table from Vertica to S3 and count the number of courses in an analytics pipeline job. Not recommended.

Steps to Reproduce

None

Current Behavior

None

Expected Behavior

None

Reason for Variance

None

Release Notes

None

User Impact Summary

None

Status

Assignee

Unassigned

Reporter

Michael Roytman

Reach

None

Impact

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Story Points

1

Actual Points

None

Category of Work

None

Stakeholders

None

Epic Link

Priority

Unset
Configure