Can a threshold be set in a Formula or Widget to limit information displayed on a dashboard graph.

Jason S.

Hello,

I am trying to set a threshold to limit the amount of information that is displayed on a dashboard widget. I currently have multiple rows of different companies and multiple columns of observation categories (In a graph setup). The populating information is being pulled in using a formula from multiple columns in another sheet.

(Formula example.... =SUM(COUNTIFS({Example Range 1}, "Negative", {Example Range 6}, "Environmental", {Example Range 9}, "Company A"), SUM(COUNTIFS({Example Range 3}, "Negative", {Example Range 4}, "Environmental", {Example Range 10}, "Company A"), SUM(COUNTIFS({Example Range 5}, "Negative", {Example Range 18}, "Environmental", {Example Range 11}, "Company A"), SUM(COUNTIFS({Example Range 7}, "Negative", {Example Range 8}, "Environmental", {Example Range 12}, "Company A")))))

To simplify, my end goal is to display a bar graph on the dashboard that shows when there have been 3 of the same observations for the same company.

Thanks!

Paul Newcome

You will need to create a series of helper columns (one for each of the existing output columns) and use a basic IF statement to only output the number if it is greater than or equal to 3.

=IF([Column Name]@row>= 3, [Column name]@row)

Then you would create a report that pulls in these helper columns filtered to only show rows where at least one of those columns is not blank.

Finally you would use this report to create your chart.

Paul Newcome

Are you able to provide screenshots for context?

Jason S.

The first is where the graph data is being pulled from (Each cell is a sum of 4 different columns from another sheet), in the second graph, I would only like it to populate if there are a total of three of the same observations as seen with the conditional formatting. Hope this helps!

Paul Newcome

You will need to create a series of helper columns (one for each of the existing output columns) and use a basic IF statement to only output the number if it is greater than or equal to 3.

=IF([Column Name]@row>= 3, [Column name]@row)

Then you would create a report that pulls in these helper columns filtered to only show rows where at least one of those columns is not blank.

Finally you would use this report to create your chart.

Jason S.

Thanks!

Paul Newcome

Happy to help. 👍️