Forum Discussion
How to disable default summarization of data
- 7 years ago
Hi Anonymous
A chart or table will always summerize when a field is added to the value secion
in your example you have added duration to the values. because the duration filed is set to "Do not sumerize" it will default to Count in this case you have 1 entry for each project in your table so your chart is showing every project as 1.
in order to show the duration value you need to use SUM as the SUM of say project 1 is 150 so that would make your chart show what your after.
for best practice you should change from "DO NOT SUMMERISE" to SUM
only Dimentions such as your project colunm should be left as do not summerise.
You have to remember that although your field for duration is already the value you want to show it cannot be input as a value it has to first be summerised. for example lets say instead of having one row with Project 1 duration 150
you had two rows as below
Project_1 75 Project_1 75 in this case you would want to sum(duration) to get a total of sum(75 + 75) =150
when there is only one row as in your example then the sum still works sum(150) = 150
i hope that makes sense
Hi Anonymous
As far as my knowledge goes, it is to do with the type of chart you are using.
If you were to use the 'Table' visualisation for your data, you will see the 'Don't Summarise' option.
I don't believe Clustered column charts allow you to bypass the summarisation. I would instead look to maybe filters and/or slicers to make the visual show you what you are looking for.
Hope that helps
Daniel