Dashboard Chart
I want to create a single dashboard chart that shows the total work planned vs the total work unplanned. I created two reports and added filters and counts; one for planned work and one for unplanned. How do I pull the counts from each report to display in a single dashboard chart?
Answers
-
I create a metric sheet and use a formula to count up what your key identifier of each are.
-
Thanks Kiela. Can I have a metric sheet pull from another sheet? The problem is I would need to create two metric sheets and then use both to populate the graph.
-
You would use a single metrics sheet and have one source sheet referenced in one column and the other source sheet referenced in another column. You can't combine sources to create a single chart.
-
How do I filter the data in a single metrics sheet to get both numbers I need for the chart? Right now, I have one source sheet and two reports. It sounds like I need to create a metrics sheet in place of the two reports, but I don't know how I would create the various filters I need in a single metric sheet.
-
You would use formulas with cross sheet references such as COUNTIFS, SUMIFS, or AVG.
=COUNTIFS({Status Column}, @cell = "Red", {Type Column}, @cell = "Type A")
