Records not counted in attribute table and symbology

[Gisbert61]

Hi all,

Pro 3.5.3 here.

I have a hosted feature layer with 4100+ records, whenever I select records they're not counted correctly:

Also when I create a symbology the count for <Null> values is incorrect:

In the above symbology I have a lot of Null but it counts zero.

Symbologies of other attributes containing Null values also count zero for the Null  value and correct for other values. (like the symbology depicted above)

This makes me feel very uncomfortable. What's wrong here?

Regards,

Bert

[JaimeSF_EsriSpain]

Hi @Gisbert61 

I have the same version than you. I try with a hosted feature layer with 1.666.956 records, and I don't have this problem, count well for me:

I don't know how it's wrong with your data 😞

[RTPL_AU]

Hi @Gisbert61 
If you add a definition query of IS NOT NULL against the field does it give the correct result?

[Gisbert61]

Hi RTPL_AU,

Nothing changes in the symbology nor the count after I add that definition query (I see less points on the map of course) but thats it..

[RTPL_AU]

@Gisbert61 
Mmm.
Do you see the correct counts in ArcGIS Online of you open the layer in Map Viewer and apply a Unique Symbols style to it using the same attribute?

Another option is to create a hosted view and seeing how it behaves.

I keep a couple of different computers on older versions of Pro for reasons - If you have something you could drop 3.3 or earlier on it might help to lock the issue down to 3.5.x or if it is a hosted service issue. 

[Gisbert61]

@RTPL_AU 

I don't seem to be able to add a count to a symbology in the webviewer, however when I create the same symbology (Unique symbols) several values are omitted in the webviewer which i can see in Pro:

  I miss 11, 12, 15 and 22.

Regards, Bert

[RTPL_AU · Accepted solution]

@Gisbert61 
While you're building the style it shows the count next to each category. 
I don't think it can be added to the actual legend. Someone should lodge an I...

Any unincluded items will show at the bottom and be counted in the 'Other' total.

[Gisbert61]

Aha, I got the count per your example, excellent.

A bit peculiar that symbology simply stops after ten items and does not display the rest automatically but okay I guess.

So I have 1576 <null> values visible as 'other'. This is confirmed by looking at the attribute table

In the mean time I have de-installed and re-installed Pro 3.5.3 so I'm at 3.5.0 until IT can start the 3.5.3 patch

[Gisbert61]

i accepted  @RTPL_AU as solution as it helped me further.

I'm still unable to get a valid count of <null> values but there might be a problem in my dataset about datetime fields. ..