Chart to Display Count of Complete vs Incomplete
Options
Comments
-
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
-
Thanks Michael!