Hello all,
What tricks or techniques do you use to calculate learning hours?
I’m calculating semi-annual learning hours for our online courses using the following technique:
- Create new ad hoc report with data sources ‘CourseUserSessionTotal_v’ and ‘Users_v’ (join data sources via ‘UserID’ field).
- Select data field ‘UserName’.
- Add pivot columns for ‘CourseName’ (Group) and ‘TotalDuration’ (Maximum). 'TotalDuration' units will be in seconds, which is easier to analyze than HMS.
- Select ‘Add Subtotals’. This will show you total seconds spent in each course.
- Add filter FirstSessionDate, Between(Calendar), 1/1/21 and (today’s date) to calculate learning hours for the year so far.
- Add additional filters as needed.
- Export resulting report as CSV or XLS file for analysis.
*Because pivot reports are limited to 100 columns, this first report will only show results for the first 100 online courses in your LMS. You can filter by course name to chunk the data. I added a filter CourseName, Is Greater Than, <name of course in column100 of previous report> to get data for the next 100 courses (but keep in mind this might clip off some users who did not take the next 100 courses).
Outputs allow you to calculate online learning hours per user, online learning hours per course, online learning hours overall, learning hours per category, and so on and so forth.
Perhaps there is a more streamlined way to get these data. Eager to hear your ideas and feedback!
Thank you,
Sarah
