Forum Discussion
Dataset or something else?
I'm having difficulty finding a way to display my employee audit score breakdown. This visual will need to contain 25 graded categories for each employee I audit in the field. Each category will have a grade of 1.00-5.00 and I am wanting the visual's categories to be a horizontal bar graph, like the image below. I've been watching videos and utilizing ChatGPT but I'm afraid my data set may not be not setup for this desired visual result or which visualization would work best?
Categories:
1. Site Introduction
2. Site Assessment
3. Time Management
4. Document Readiness
5. Hardware Requests
6. Device Readiness
7. Inner-team Communication
8. Vendor Management
9. Daily Store Updates via SharePoint
10. ITCT Playbook Utilization
11. Checklist Utilization
12. Network Tools Utilization
13. Ping Script Utilization
14. Device Placement & Installation
15. Cabling Installation
16. PPE Compliance
17. Overall Workplace Safety
18. Customer Driven (Core Value #1)
19. Integrity (Core Value #2)
20. Work Ethic (Core Value #3)
21. Innovative Thinking (Core Value #4)
22. Perseverance (Core Value #5)
23. Task Prioritization
24. Task Completion
25. Time Wasted
Desired visual:
View of my data set:
Each row represents an employee's audit.
Unpivot all your columns except the first (assuming this is Person), this should result in a long table with 3 columns: "Person", Attribute "Category", and Value "Score".
You should then be able to throw the Category and Score into a bar chart as desired and filter for specific people.
1 Reply
Unpivot all your columns except the first (assuming this is Person), this should result in a long table with 3 columns: "Person", Attribute "Category", and Value "Score".
You should then be able to throw the Category and Score into a bar chart as desired and filter for specific people.