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
-
-
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.
-
-
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.
