Is there a way to specify which rows I want in a metrics sheet for widgets?

Mary Vogt

Hi,

I have a metrics page that links to a sheet with data on it. The metrics I am interested in are attached. On the dashboard, we are using a donut graph to show all four categories: Red, Green, Yellow, Gray. But now I want to create another one that only shows Yellow and Grey metrics (e.g., 5 hour training completed percentage, and 5 hour training not completed percentage).

Is there a way to do this without having to create a new metrics page? Thank you for any help.

Paul Newcome

You can replicate the metrics using cell linking into a new section of the sheet. Just retype "Yellow" and "Gray", then use a basic cell reference to the current data counts so that you can ensure the two numbers actually match.