topic Re: Why does quantities graduated colors show different values? in Data Management Questions

Why does quantities graduated colors show different values?

Xavervon_Beckerath — Tue, 03 Mar 2020 20:24:42 GMT

I am currently working on a heatmap and trying different ways of visualizing my data. I used unique values in combination with labels which worked fine.

However, it may be to confusing for a research paper and and I decided to use quantities instead. Unfortunately, using the same value I get very strange numbers that are not present in my dataset.

I haven't used ArcMap in while but this does not seem right to me. Does anyone know what the problem is?

Re: Why does quantities graduated colors show different values?

DavidPike — Tue, 03 Mar 2020 20:46:56 GMT

What's with the 3 comma separated values showing up on the unique values and your table of contents? Your attribute table seems fine as it doesnt have them. What data type is the field?

Re: Why does quantities graduated colors show different values?

Xavervon_Beckerath — Tue, 03 Mar 2020 20:51:17 GMT

I noticed that too but ignored it as unique values worked fine. The field is "Double".

Re: Why does quantities graduated colors show different values?

DavidPike — Tue, 03 Mar 2020 21:03:59 GMT

I've never seen that before. Can you add a new field as float and use field calculator to calculate the same values and retry on that field. What does it look like if you based one of those values from the total column into excel?

Re: Why does quantities graduated colors show different values?

Xavervon_Beckerath — Tue, 03 Mar 2020 21:18:14 GMT

The new float column has the same issues. However, I noticed some <Null> values in my data. This may be a result of joins.

I'm not sure if I got your second question right. Copying the data in Excel makes them formated as "general".

Re: Why does quantities graduated colors show different values?

DavidPike — Tue, 03 Mar 2020 21:56:06 GMT

I think the joins or relates are messing things up. Right click on your feature in the table of contents and go to data->export and create a new feature.

Re: Why does quantities graduated colors show different values?

Xavervon_Beckerath — Wed, 04 Mar 2020 11:55:59 GMT

Exporting the feature to a new geodatabase did not solve the problem. Also exporting it to a shapefile made no difference. I fail to understand the issue as the attribute table looks fine. I can try getting rid of the <Null> values by changing them to "0".

Re: Why does quantities graduated colors show different values?

Xavervon_Beckerath — Wed, 04 Mar 2020 13:56:22 GMT

I replaced all <Null> with zeroes, same problem.

Re: Why does quantities graduated colors show different values?

Xavervon_Beckerath — Tue, 10 Mar 2020 14:09:06 GMT

I found a workaround for this problem. I have to correct my previous statement that the numbers seen in the first picture are "not present in my dataset". In fact, they are in a column called "NONE" and causing the issue. By creating a new column "NONE2" and deleting "NONE", the data can be displayed correctly.

This is due to the strange behavior of the "normalization" option in the symbology. The default value is "none" and it will take every field into account with that name (ignoring upper and lower case letters).

In summary, you should avoid to have any fields named "NONE" in your attribute table.