Dashboard Bar Chart - Duration by Resource
We use very basic project sheets using columns task name, duration, start, finish, assigned to and status. Our task durations are mostly specified in hour or minutes, but occasionally in days.
I am trying to create a simple dashboard with a few charts but having difficulties.
Chart 1 - Bar Chart - Total Duration (in hours) by Resource
Chart 2 - Bar Chart - Total Remining Duration (in hours) by Resource (tasks where status not equal to complete)
Is the first problem that you can use the Duration column as a number? I have read numerous articles about helper columns but have not found one that works to convert duration (regardless of being specified in hours, minutes or days) to hours.
In the dashboard chart widget, for columns included, it defaults to All columns, no matter what i try to change it to I get the error "The selected columns cannot be charted"
Any help would be greatly appreciated.
Ken
Answers
-
Are you able to provide a screenshot of a project plan that shows each of the different duration increments (minutes/hours/days)?
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
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives