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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives