broken line graph in dashboard
I'm trying to understand why these line graphs are displaying the way they are:
I've got this graph defined like this
and the data looks like this:
Any ideas?
Best Answer
-
Your question led me to the answer. Clicking on the .00 button a few times revealed that what all appeared to be numbers were actually being treated as a mixture of text and numbers.
Converted them all to numbers, ensured they showed up that way by clicking on the .00 button, and the graph is displaying as expected.
This is a really frustrating part of SmartSheet's text/number column type.
Answers
-
Which column are you using to generate the lines?
-
The label column is serving a the label, and several of the columns with integers in them (with pixelated column headers in my image above) are providing data for the y values for those lines.
The screenshots show all the data, there are no empty cells, not clear to me why there are broken lines.
-
How are you populating the source data exactly?
-
Your question led me to the answer. Clicking on the .00 button a few times revealed that what all appeared to be numbers were actually being treated as a mixture of text and numbers.
Converted them all to numbers, ensured they showed up that way by clicking on the .00 button, and the graph is displaying as expected.
This is a really frustrating part of SmartSheet's text/number column type.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
