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.
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.