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.
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.
-
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. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives