Pie Chart from Report?
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
I've got a similar question, though with different issues.
I've got multiple sheets that I've summarized in a report. Both sheets have columns for "estimated hours (EH)" and "remaining hours (RH)" for each task. There are hundreds of tasks, per sheet, but in the report I filter so that it only displays the "Active Sprint" tasks, which are marked with a flag checkbox.
In this report, I am able to display the total remaining hours, and the total estimated hours.
I'd like just a pie chart to pop up , either in this report or in a seperate portal, that shows two colors:
for example, red = RH, blue = EH-RH (hours completed)
Any recommendations for how to do this as efficiently as possible?
-
Hi David,
To do a chart, you need to pull these two values in a separate report or a sheet. Once you have it ready, create a dashboard or in an existing dashboard, you can add the chart widget and select the sheet/report which contains this data to prepare a pie or donut chart.
Thanks,
Aravind
Associate Director
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: aravind@copernicusworld.com
Feel free to reach out for licenses, services, and training on Smartsheet
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives