Categories
HCM Learning - Redundant item rating metrics
What is the difference between the "Average Learning Item Rating" and "Overall Learning Item Rating"?
the calculation logic sheet shows the same formula for both. Is there a reason to pick one over the other?
Best Answer
-
Overall Learning Item Rating = Sum(Rating)/Count(Rating) where Rating is not null
This is an Overall Rating without consideration of any dimension like Learner, Learning Item, Workforce attributes like Department, Job Code. Would be suitable for Performance Tiles in Workbooks where dimensions are not used.
Average Learning Item Rating - Workforce Structures has similar formula. However, this metric should be generally used along with dimensions like Learning Item, Learner, Workforce attributes like Manager, Job Code, Location, Department etc. This metric is more granular. It is suitable for Pivot tables, Graphs, Tables etc where dimensions are shown. This metric represents the average rating at the grain of the dimension member.
Overall Learning Item Rating will be a constant value across the grain of dimension.
Average Learning Item Rating would vary across dimension members.
1
