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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives