How can I make a pie chart that aggregates dropdown choices in a column?
I have survey results that I need to make into a chart - for example, let's say for a question where they rate something from 1-5. Ideally, in a pie chart, it would show that x% of respondents answered 4, x% of respondents answered 5, etc. But instead, each row is getting its own pie slice.
How can I make it so that it's counting each answer choice as a percentage of the whole?
thank you in advance!!!!
Best Answer
-
The way I would do this is to make a metrics sheet that reads from the your survey results and does the counting, and then use the metrics sheet to create your graph:
Create two columns in your metrics sheet, "Rating" and "Count"
Create a row for each rating, 1 through 5. In the count column for each of these five rows, use a formula to count the total responses in your survey responses sheet that equal that rating. When building your COUNTIF formula, use the Reference Another Sheet link that comes up after you type =COUNTIF( to select the Rating column from your response sheet:
=COUNTIF({Survey Response Sheet Rating column range}, Rating@row)
On your dashboard, add your chart widget, selecting your data from the metrics sheet.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
The way I would do this is to make a metrics sheet that reads from the your survey results and does the counting, and then use the metrics sheet to create your graph:
Create two columns in your metrics sheet, "Rating" and "Count"
Create a row for each rating, 1 through 5. In the count column for each of these five rows, use a formula to count the total responses in your survey responses sheet that equal that rating. When building your COUNTIF formula, use the Reference Another Sheet link that comes up after you type =COUNTIF( to select the Rating column from your response sheet:
=COUNTIF({Survey Response Sheet Rating column range}, Rating@row)
On your dashboard, add your chart widget, selecting your data from the metrics sheet.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 381 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives