How do I get blank fields to show up on a Chart Widget?
How do I get blank fields to show up on a Chart Widget, they show up on my report as Summary "0" because the fields are not filled in so they do not translate to the chart I have on my DB.
Thank you for the help!
Answers
-
Hey Kimberly,
How would you like the Blank to show?
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Hi - I would like it to show up as a percentage in the pie chart. Thanks!
-
You are goin to need to use a separate metrics sheet with cross sheet formulas instead of a report.
-
Thank you! I updated my summary sheet and then created a summary report and it now accurately displays all statuses, including the blanks.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!