broken line graph in dashboard

Tony Rice

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?

Tony Rice

https://community.smartsheet.com/discussion/comment/293661#Comment_293661

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.

Paul Newcome

Which column are you using to generate the lines?

Tony Rice

https://community.smartsheet.com/discussion/comment/293647#Comment_293647

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.

Paul Newcome

How are you populating the source data exactly?

Tony Rice

https://community.smartsheet.com/discussion/comment/293661#Comment_293661

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.

Paul Newcome

Happy to help. 👍️