Charts plotting 0

Hi all,

I am trying to come up with a formula to avoid showing 0 on a chart for a dashboard. I am using this formula but I am getting an incorrect argument

=IF(COUNTIFS({GIH Globalization Project Tracker Range 9}, "Product") > 0, COUNTIFS({GIH Globalization Project Tracker Range 6}, "Approved", {GIH Globalization Project Tracker Range 5}, "Q1 FY21"))

Basically I am trying to see how many products were approved in Q1 and if the number if 0, for that cell to show up as blank.

HELP!

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Sandra Vulis Petrosyan

Hope you are fine, could you please supply a screenshot ( remove any sensitive data ) to help me to write the exact formula for you

Sandra Vulis Petrosyan

Hello Bassam,

Thank you for reaching out. Below is how my source sheet is set up. The information is being fed from a separate project tracker

I am basically trying to set up a dashboard of approved products for the fiscal year without the zero's showing up on a chart. Thank you in advance.

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