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?

Find more posts tagged with

Accepted answers

Paul Newcome

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.

All comments

Paul Newcome

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.

william_ma

https://community.smartsheet.com/discussion/comment/407978#Comment_407978

Thanks Paul.

After I added this summary to the roll up report, I can load the data and build the pie chart. spot on!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.