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 |