Why keep getting this "Selected data can't be charted." Error in Dashboard loading a Row Report?
What I intended to do is super simple: bring two sheets into one Row Report and do a simple pie chart on the status field.
-> Source Data: two sample sheets A&B have exactly same fields.
and the status is a dropdown list with single value
-> The roll up row report, only picked the status field from the two source sheets.
-> then from the dashboard, add data from this report
Can't the Dashboard just load the data and do the pie charts by counts? Did I do anything wrong here?
Best Answer
-
You need to give the chart numbers to chart. Use the grouping and summarize features within the report to generate the counts. Then you will be able to chart from the report.
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!
Answers
-
You need to give the chart numbers to chart. Use the grouping and summarize features within the report to generate the counts. Then you will be able to chart from the report.
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!
-
Thanks Paul.
After I added this summary to the roll up report, I can load the data and build the pie chart. spot on!
-
Happy to help. 👍️
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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
