Can someone help me with my column chart data from a report?

I have all the information in a Sheet, which has been imported. So I created a Row Report and selected the basic information (Action Stage = BAU & Backlog and Status = open, overdue etc). Within the dashboard column chart, I cannot seem to generate the Action Stage split out as BAU or Backlog along the horizontal axis with columns showing the quantity of each status. This is what I want……

This is what I am getting….

I hope you can urgently help.

Thanks

Yvette

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide a screenshot of the source data?

Yvette.C

Hi - thanks for getting back to me.

The report data is below. I would like to count the number of Status per Action Stage and then add it into a Column Chart but when I add a summary of count to the Status it just brings up the same number, rather than splitting it out.

I'm looking for something similar to this that was quickly created on Excel….

Thanks for your help

Antonie B

@Yvette.C ,

I can see the logic behind your steps! The issue is that in the report format, the chart only honors the first level of grouping!

For your use case, I recommend creating a metric sheet with the same layout as the table in your final screenshot. If you name the columns as the Status i.e. "Completed" you would then use a cross sheet COUNTIF formula to pull the results.

https://help.smartsheet.com/function/countif

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

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