Chart Widget
Hello,
I'm creating a dashboard of a program status. I'll like to display a bar chart where I can see in the column the name of the Project and inside the number of activities per status.
Like a cumulative columns whit all the status per project
Vertical axes: #Task
Horizontal Task : Projects
Data display in a bar : # task per status
Is this possible?
Best Answer
-
Yes! You would need a sheet that has the data in question to create a dashboard from. Is this data being sourced from a project sheet?
Here is an example below:
I have a metric sheet that evaluates data from my project sheet.
An example of the formula that calculates this would be =COUNTIF({Status}, "Complete")
This looks at the Status Column of my project sheet and looks for the status to match the value in quotes "Complete". This is showing that 20 tasks have been completed. I can then highlight this data in a dashboard widget.
I can then highlight this data and add it to a dashboard chart widget.
To add titles to the axis you can edit that in the chart widget editor.
Answers
-
Yes! You would need a sheet that has the data in question to create a dashboard from. Is this data being sourced from a project sheet?
Here is an example below:
I have a metric sheet that evaluates data from my project sheet.
An example of the formula that calculates this would be =COUNTIF({Status}, "Complete")
This looks at the Status Column of my project sheet and looks for the status to match the value in quotes "Complete". This is showing that 20 tasks have been completed. I can then highlight this data in a dashboard widget.
I can then highlight this data and add it to a dashboard chart widget.
To add titles to the axis you can edit that in the chart widget editor.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives