Dashboard chart from sheet

Hi all,

I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue.

However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...."

Any advice if I can do this or it just isn't with the functionality?

Screenshot 2021-06-16 at 10.04.22.png

Thanks in advance!

Find more posts tagged with

Sheets

Dashboards

Accepted answers

Mark Kapsa

RSP,

We are using the sheet symbols as well in one of our status reports. We are counting the status icons in that sheet in a set of columns using =countif(column:column, =Color#) as each status icon has a specific number to it. You can then create a chart based off that data. However, if you do not want that set of columns to be on the source sheet I would suggest creating an intermediate sheet for just generating the chart data and use "reference another sheet". Also, you can count in the sheet summary, but you cannot chart from it, you could use a metric widget to display the values.

All comments

Mark Kapsa

RSP,

RSP

Thanks Mark,

I have created the intermediate sheet and that works well. I shall use this going forward.

tscottp

@RSP I have the exact same issue (thanks for sharing that screen shot). Could you please share how you built the intermediate sheet?

Thanks

Scott

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.