Forum Discussion
Make a column not sum/count
I have this issue too. I tried all the suggestions but still get this count. Here you can see that it is labled as do not summarize and as text. This Location field is city, state combo. As you can see it is doing this for both the location field and the in/out texas field.
nzipp It'd be better to start a new thread than continue on the end of an old one but...
A scatter chart requires each axis to be numeric. You can't put text fields on the axis (unless you want to count them, which is what it's doing). You might want to look at a different type of visual, such as a matrix, depending on what your end-goal is.
It's not an old thread as it is still actively being posted to; 4 hours ago and last month for example, by you Leo. Also, when creating dashboards everyone gets tired of looking at the same style graphs and it's important to vary it up with other styles. I have worked with numerous reporting tools and they have all been able to use scatter in this fashion; as seen below.