How to create a chart for accrued hours by 3 individual
Good day everyone,
I am currently trying to create a graphical / numberical represenstation of accrued hours by 3 individuals to visually representing their total accrued hours in a sheet.
Basically, the sheet/form is running accordingly with manager's approval and all the factors.
How can I create a Dashboard (with bar graph or just a number) to reflect the total hours these 3 individuals as accrued in simplest form of
Mr. A = xxx Hours
Mr B = xxx Hours
Mr C = xxx Hours
Best Answer
-
I would suggest creating a row report that references the sheet. You can then group by name and then use the report summary feature to get your totals. Finally, you would use this report as the source data for a bar chart.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
The form is something like this.
-
I would suggest creating a row report that references the sheet. You can then group by name and then use the report summary feature to get your totals. Finally, you would use this report as the source data for a bar chart.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes that works!! Thank you so much for your tips.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.6K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives