Dashboard Charts- Remove Data without Value

Scott Prater

Hi All,

I've created a dash and have a chart where I'd like to display data that does not include descriptions with zero values. Below details the dash/chart as it currently stands.

I would like to get rid of the lines without a value (remove Abduction Pillow, Bed alarm, etc.).

Here are my metrics- can't seem to figure this out. This would be extremely useful in multiple applications so any help is greatly appreciated! Thanks!

PS I did find this from Paul Newcome in another post, but cannot figure out how to apply it:

"Insert another column and use a formula such as

=IF([Column With Count]@row <> "", [Column With Label]@row)

Then you can reference this column in your chart."

Paul Newcome

What you will actually want in this case is to create a report and have it only include rows that are greater than zero. Then you can reference this report in you chart widget and it will be dynamic so that bars are added and removed automatically as rows are added to/removed from the report.

Scott Prater

Made a report with a few problems:

1. can't seem to change the info populating in the primary column. I don't need that data (inked out).
2. When I try to create a chart widget based on this report I get "selected data cannot be charted. please select a new range".

What am I doing wrong?

Paul Newcome

You are not going to be able to get rid of the Primary column. That is where your chart labels should reside. The only other column you want included in this report would be the column with numbers.

Scott Prater

I figure it all out, Paul- thank you for setting me in the right direction. You are a terrific resource and I genuinely appreciate it!

Paul Newcome

Happy to help. 👍️

jeff steffen

Hi there, I have a metrics sheet like the one above and want to remove zeros in my chart. I know previous member resolved but not sure how. When I use the greater than zero, it removes all of my data.

Thank you

Paul Newcome

@jeff steffen What is the formula you are currently using that is removing all of the data when greater than zero?

jeff steffen

I was just using filter, no formula

Paul Newcome

@jeff steffen How exactly are you populating the numbers for your chart?

jeff steffen

I am referencing master sheet, then creating a chart from metric sheet

Paul Newcome

@jeff steffen Did you create the report as previously suggested in this thread?

jeff steffen

This is how my report is coming over from sheet. Did I do that right?

Paul Newcome

@jeff steffen No. The report should only have the rows and columns that will actually be charted.