Chart to Display Count of Complete vs Incomplete

Jennifer Dewhurst

I am trying to display a chart on a dashboard that displays Complete vs incomplete items using a single column on one sheet as a source.  Should I create a report, then generate a metric widget? What is the best way to do this? 

Michael Kingsbury

What i do is make another "Utility" sheet and use a COUNTIF()/ COUNTIFS() formula. 

IE 

Completed Items                                                

=COUNTIF({Sheet Range 1}, "Completed")       

Incomplete Items

=COUNTIF({Sheet Range 1}, "Incomplete") 

 

After that use the Metric widget and display those items. It will auto update after you make changes in your sheet which is nice.

 

If you want more criteria use COUNTIFS() Like Completed items that are in "X" Department or whatever.

Michael 

Jennifer Dewhurst

Thanks Michael!