Analytics: Add new analytics and optimize query - Githubissues

jhuopensource / semesterly

Your Semester Made Easier | Course Scheduling & Social Tools for Students

https://semester.ly

GNU General Public License v3.0

33 stars 56 forks source link

Analytics: Add new analytics and optimize query #998

Closed jchen324 closed 1 year ago

jchen324 commented 1 year ago

Description

Add statistics for number of users by major, number of signups per day for the past month, and most_popular_courses overall
Get rid of the for loop by utilizing pure SQL approaches for the functions number_students_by_year() and number_students_by_major()
Increase number of color schemes for chart
Show dates on the chart

Change Log