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")
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives