Forum Discussion
How to disable default summarization of data
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
Solution SageHi im not sure what you are trying to accomplish but i think the issue is that you have the colunm in teh values filed
a value filed will not allow a non sumerized value as the value is always an aggregated field so will only allow a MAX.MIN,COUNT SUM etc.
if the filed is moved to the Ledged, or axis filed of the visual tehn it should work fine with teh settings you have
if there is something i am missing then please let me know and i will try to help.
preferable show a screen shot of your visual and some sample data
Regards
hi AnthonyTilley ,
I think this is a dummy question but it is important for me to understand where I am wrong.
I will give another example. I have a table with two columns (projects and duration) and I would like to visualize in a chart duration for each project. How to do it? Because as you can see from the screenshots below chart is showing count value for each project which doesn't have any sense for me. So how to avoid counting or any other summarisation in charts? By the way, summarisation is set to the Don't Summarise under "Modeling" tab for the duration column.
Thank you very much for your help.
- AnthonyTilley
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