Columns without "sum" symbol are loaded as a chart count

[Syndicate_Admin]

Hello community!

I find a problem when loading information from columns to a graph, it happens that every time I try to load a column to some axis it appears as "count of" column instead of loading the value that it should, I noticed that it is when the symbol of "sum" (Σ) does not appear but when it appears I do not have this problem

 

in the image that I attached it is possible to see that when I load the date field (date) it makes me the count, but with the field of n° that if it has the symbol Σ (you can not see in the photo but if it does) it does not give this problem, how can I make the fields that I need to import have this symbol Σ or that simply do not count values? in advance thank you very much

 

[v-xiaotang · Accepted solution]

Hi  @Syndicate_Admin 

It seems that the fields you are using are strings not numeric, thus you only have the count or distinct count option.  You need to convert these to numeric (go to the Modeling tab and change the Data Type) and then you can perform aggregations like sum, average, etc.  If there is only one value per X axis increment, then these aggregations will return the actual value.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

I understand, I also noticed that only the "sum" thing happened with the non-numeric columns, on the other hand, do you know of any method that you can use to show the dates as dates and not as a count? what I need to show is for example: 01-01-2022, 02-01-2022, 03-01-2022, etc. and not counting dates 3, how could I do this? thank you very much for your help

[v-xiaotang]

Hi  @Syndicate_Admin 

Thanks for your reply.

What visual are you using? Some visual fields do not support placing dates, only numeric types are supported, and the date will be automatically converted to count/count(distinct).

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , In the column tools, You can choose - Summarization - do not summarize

In the property pane in the model view, you can change for more than one column of same type

[Syndicate_Admin]

Hello! and thanks for answering!, it happens that when reviewing those column options in the columns that appears as "count" the option of not summarizing is activated by default, therefore that is not the problem, another thing I noticed is that when I open the drop-down menu of the summary, in the fields that I say only count or non-count appear while in other fields more options appear as sum, average, minimum, maximum, etc., what may be causing this? thank you very much in advance