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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives