FAQ: Is it possible to report on the ‘Total completed hours’ using OData?

The Users OData table provides a number of Learning Plan summary fields – all these have “UserLearningPlanSummary_” prefix.

The “UserLearningPlanSummary_CompletedTime” field corresponds to a Learner’s Total Completed Hours metric, returned as the sum of minutes. Please apply manual conversion into hours, if needed.

For example, the Odata returns ‘"UserLearningPlanSummary_CompletedTime": 1584’: dividing 1584 by 60 [minutes], you get 26.4 hours, which should be interpreted as ‘26 hours and 24 minutes’.

Note that “UserLearningPlanSummary_CompletedTime” field returns the same as the ‘Completed’ hours value you can see from both Learning Plan Overview page (in Classic) and Off-The-Job Hours widget in Learner Dashboard.

image-20250430-093205.png

 

image-20250430-093216.png

 

Was this article helpful?
0 out of 0 found this helpful