Forum Discussion
How do I get my data to NOT sum when creating visualizations?
Hi, I'm creating my first visualization. My query shows enrollment numbers (students enrolled in a school) by month and year. When I go to create the visualization, the data automatically sums. I do...
Thanks for the quick response! Now it gives me the “count” instead of the actual number. Thoughts?
Have you verified the data type of the column of data you are using?
Also, recheck the do not summarize because that same aggregate/non-aggregate area has a count and a distinct count. Double checking never hurts and we have all clicked a little too quickly and caught the wrong selection at one time or another. You can do this from the visual by clicking the drop down area by the field name and selecting do not summarize there for the actual visual.