Skill (Summary by Skill) Report

Use the Skill (Summary by Skill) Report to monitor all the skills your users are following, including the total number of users following a skill, the total number of users who have ratings for the skill, and averages for each rating type for the skill.

Permissions may be required to access some pages in Degreed or perform specific tasks. For more information, see Permissions in Degreed.

Required Permission: Manage In-App Reporting

This report includes a required date range column filter with a default date selected. We recommend modifying the dates to extend the date range to include additional data. See Filter an In-app Report for more information.

Direct Data Connector table name: Skills_Summary_SkillSummaryBySkill

Column Name	Column Description	Enabled by Default	Direct Data Connector Field Name	Data Type
Skill Followed Date	The date the skill was followed by the user. This is the date range column located on the Filter dialog.  The column is not included in the report results.	Required	SKILLFOLLOWEDDATE	DATE
Skill Name	The name of the skill.	Required	Skillname	char
Total Skills Followed	The total number of users following the skill.	Y	Add COUNT(Skills_Summary_SkillSummaryBySkill.employeeid) to your query.	integer
Total Skills Focused	The total number of users focusing on the skill.	Y	Add SUM(Skills_Summary_SkillSummaryBySkill.skillfocuscount) to your query.	integer
Total Self Ratings	Total number of users who have self-rated the skill.	Y	Add COUNT(Skills_Summary_SkillSummaryBySkill.internalselfratings) to your query.	integer
Total Manager Ratings	Total number of users with a manager rating for the skill.	Y	Add COUNT(Skills_Summary_SkillSummaryBySkill.internalmanagerratings) to your query.	integer
Total Skill Reviews	Total number of users with a skill review for the skill.	Y	Add COUNT(Skills_Summary_SkillSummaryBySkill.internalskillreviews) to your query.	integer
Total Peer Ratings	Total number of users with a peer rating for the skill.	Y	Add COUNT(Skills_Summary_SkillSummaryBySkill.internalpeerreviews) to your query.	integer
Average Self Rating	The average self-rating for the skill.	Y	Add CAST(AVG(Skills_Summary_SkillSummaryBySkill.internalselfratings) AS DECIMAL(5, 2)) to your query.	numeric
Average Manager Rating	The average manager rating for the skill.	Y	Add CAST(AVG(Skills_Summary_SkillSummaryBySkill.internalmanagerratings) AS DECIMAL(5, 2)) to your query.	numeric
Average Skill Review	The average skill review rating for the skill.	Y	Add CAST(AVG(Skills_Summary_SkillSummaryBySkill.internalskillreviews) AS DECIMAL(5, 2)) to your query.	numeric
Average Peer Review	The average peer review rating for the skill.	Y	Add CAST(AVG(Skills_Summary_SkillSummaryBySkill.internalpeerreviews) AS DECIMAL(5, 2)) to your query.	numeric