Create a Chart based on Multi-Select Dropdown
Hello!
I have two columns called "Customer" & "Feature Request". "Feature Request" is a multi-select dropdown...essentially anytime a customer asked for a feature I toss in the FR# in there to track. The same FR# can show up for each customer. Been youtubeing/reading to death but cant figure out how. The auto-chart selection mechanic isnt telling me why it wont work.
Chart - Pie/Donut Chart showing how many times each FR is being asked (if 5 out of 10 customers asked for FR123 then show 5 in the pie chart)...essentially showing which FRs are being asked about the most.
If I have 20 FRs, I want the chart to proportionally show the most requested items as larger slices/%'s.
Answers
-
Hi @degd
Chart Widgets need numerical data in order to map the information into bars/pie charts, etc.
What I would do in this instance is have a helper "metric" sheet which will be the source for your chart. Down one column, in a single cell each, list out each individual Feature Number. Let's call this "Feature Number".
Then in a column next to this, use a cross-sheet formula to COUNT how many times that specific number was selected in your source sheet:
=COUNTIF({Feature Request Column}, HAS(@cell, [Feature Number]@row)
See: Cross-sheet formulas , COUNTIF Function , and HAS Function
Let me know if it would be helpful to see a screen capture example of how to set this up and I'd be happy to explain further.
This will allow you to have a metric sheet where each individual selection has an associated number. Then you can use the entire sheet as a source for a Pie Chart, which will show you the percents or the values, depending on what you'd prefer.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives