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.
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.
-
Yes that works!! Thank you so much for your tips.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives