Help with creating a dashboard
I am needing to create a dashboard for the sheet I have listed below. The employee owner and task associated columns are both drop down columns and I am needing to create one chart for each employee to show the amount of hours for each task associated. For example, I want a chart for Vince Greco that reflects a total amount of panel build hours, redlines hours, PTO hours, and training hours and a separate chart to show the same for Aaron Cooper. Can someone help me out with exactly how to create this?
Thank you!
Best Answer
-
Good afternoon, @Michaela B!
I have done similar charts by first creating a report that filters just for the desired employee, in this example, Greco. You will want to Group the report by 'Task' and then Summarize the report w/ Sum of 'Hours'. The end result should look something like this:
Once you have the report showing the data you want, you will build your dashboard chart by selecting the Report, not a range from the sheet. When you do, you will get something like this:
I hope this helps! @Stacey C
Answers
-
Good afternoon, @Michaela B!
I have done similar charts by first creating a report that filters just for the desired employee, in this example, Greco. You will want to Group the report by 'Task' and then Summarize the report w/ Sum of 'Hours'. The end result should look something like this:
Once you have the report showing the data you want, you will build your dashboard chart by selecting the Report, not a range from the sheet. When you do, you will get something like this:
I hope this helps! @Stacey C
-
Thank you so much @Stacey C.!!
-
Happy to help! Have a great afternoon!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives