Sql query to obtain avg rating for one learning report in BI publisher
Summary:
Rating column for Learning Report
Content (please ensure you mask any confidential information):
I am working one report about learnings and i need to calculate the avg rating measure.
I tried to obtain using: ACTUAL_SCORE column from WLF_ASSIGNMENT_RECORDS_F but i don't have results and i am not sure if that's the right column.
Version (include the version you are using, if applicable):
ROUND(AVG(CASE
WHEN warf.ACTUAL_SCORE IS NOT NULL
THEN warf.ACTUAL_SCORE
ELSE NULL
END), 2) AS Avg_Rating
Code Snippet (add any code snippets that support your topic, if applicable):