Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to disable default summarization of data

Hi I have read a bunch of similar questions related to my one, however, I was not able to find a solution to fix my issue. I have a "whole number" data type column which I have calculated, and I wo...
  • AnthonyTilley's avatar
    AnthonyTilley
    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_175
    Project_175

     

    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