Forum Discussion
Make a column not sum/count
michaeljc70 if I understand you correctly you have not created a measure, you are just dragging the columns to the visualisation.
Do avoid the aggregation happening:
1. Find the field in question in the Values field of the Visualisations Pane
2. Click the small arrow to the firght of the column name
3. Click 'Don't Summarise'
Picture below, hope that helps.
Thanks for the reply. But as I said, there is no option to not summarize it.
In doing some more research, I think the reason it is doing a count is because the column has "N/A" in some rows and it thinks it is a character field. I transformed it to get rid of the N/As and make the column a number. Now I see more options like Average, Minimum, etc. but no option not so summarize.
I'll add when I put all 3 fields in a table, it looks right and there is no counts or aggregates.
I changed the period field (so it sorts properly) and used sum on my number columns and it looks right now. I still don't have an option to not summarize, but since it is showing the right values, I guess it is okay.