Creating a graph from 3 variables

Hello,

I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example:

I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new range."

Any help would be awesome! I am open to change the way the variables are noted above, if it helps.

Thank you,

Purna

Find more posts tagged with

Reports

Dashboards

graphs

Accepted answers

All comments

Gia Thinh

Hi purna.desai,

Add a blank Helper column in your sheet, then set Group by Helper column and Count setting as screenshots below. Hope it works for you.

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.