Forum Discussion
Displaying Column numeric value with Date on X-Axis
Since it is only one point it doesn't make a difference if you use average, max, min since it will return the only value.
Count will count the amount of values for each date that is 1.
The summarization that you highlighted is the default summarization, what doesn't guarantee that is the one being used by the visual.
Please click on the arrow that I marked with a red circle and choose "Don't Summarize"
Hi Jorge,
I dont know why i am not able to see the 'dont summarize' option when i click the arrow that you highlighted. Please see below;
It's probably because of your data model. Try using max and check if you get the desired result.
Actually using average also gives me the desired result but was wondering is that a normal behaviour. Should i try changing the data type from Whole Number ?
The Summarization options depend on the visual you're using. In line chart visual, "Do Not Summarize" is not available but in a table visual it is, for example.
I see, so i guess the best way is to maybe use an average value or use the max as it will solve the issue in my case.
Since it is only one point it doesn't make a difference if you use average, max, min since it will return the only value.
Count will count the amount of values for each date that is 1.