When reporting in Analyze on how much time a learner has spent in a course, the good news is that there is a field available. Unfortunately, this field is reported in seconds, which is not so great for a course which can last over 40 hours.
Two possibilities:
As with date fields, add an option to select whether you want the time displayed in seconds, minutes, or hours.
Allow calculated fields which let us specify how the data is formatted
Thank you for the additional context - I can certainly understand why having multiple versions of this field would be valuable to enable usage in different widget types. We'll keep an eye on this idea and see how many other clients would benefit from this enhancement to determine when we can look to prioritize it for the roadmap.
Thanks for the formula.
Unfortunately, I don't see a way to use a formula for a "row" field. Our clients (State governments) are looking for a report with learner name, overall course score (don't get me started on that one), time spent, and then their score for each section of the course.
For columns, we have the section names (chapters). For values, we have the scores in those sections. So the only way to get all the needs met is to use time spent as a row - but then no calculation.
Thank you for sharing the formula for displaying time spent as hours, I'm including a screenshot of the formula and an example widget for reference:
Formula:
Example widget:
What I have been doing as a work around, is modifying the formula so it either shows minutes or hours.
sum([Time Spent (sec)])/60 for minutes or sum([Time Spent (sec)])/3600 for hours.. Then just rename the title so it is clear.
Great idea!
I completely agree. Due to legal requirements, some of our European entities need to report on time spent learning. To measure this only by seconds is not realistic. Agree with both possibilities mentioned above, however option 1 would be the ideal.