Metric sheet filter for Dashboarding
Hello: I have a Metric Sheet that I use to feed data into a stacked column graph in the dashboard. The Metric Sheet has rows and rows of data each with a Totals column. For those rows with 0 in the Totals, I exclude them in the data for the stacked column graph. I've tried to apply a filter which removes the 0's so that those data records won't be sent over to the dashboard; but that filter didn't work. In other words the 0's show up in the stacked column graph unless I manually delete those rows. Is there a way to have the filter work so that I don't have to always delete those 0's rows each time the data is updated?
Answers
-
Try building a report of the metric sheet specifically for the dash board. Then you can filter out what ever you need. I have had to use this solution a couple of times.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thanks! But then there's another problem. The Report doesn't let you create a stacked column graph in the dashboard. Only a Metric Sheet allows the creation of a Stacked Column Graph. I'm stuck it seems.
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