Excluding All Categories with 0s from Dashboard Graph

I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater than 0 will be represented on a (bar)graph on my dashboard. Here is a snapshot of my sheet

I have tried both of these methods pictured below:

and

If someone could let me know what the easiest solution would be to being able to show this data on a bar graph showing only the columns with values greater than 0 it would be greatly appreciated!

Find more posts tagged with

Sheets

Reports

Dashboards

Filters

graphs

Accepted answers

All comments

Kerry St. Thomas

Reports filter for rows, not columns. My thought is transpose your sheet, so that instead of one data row with lots of column headers, you just have two columns: Dimension and Value. In the Dimension column… add what's currently all your column headers. In the Value column… the values for each dimension. Then you can create a report that filters for Value <> 0… and use that report for your Dashboard widget.

Happy Smartsheeting!

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.