topic Re: Unique value counts won't refresh correctly after changing layer's data source in ArcGIS Pro Questions

Unique value counts won't refresh correctly after changing layer's data source

BrettGoodwin — Wed, 10 Aug 2016 15:02:00 GMT

First off, I'm happy to see the ability to sort by value count in the symbology pane for a layer in Pro. Unfortunately, after changing the data source for a layer, the value counts don't refresh properly and sorting by count stops working. Value counts that should now be zero are denoted with a question mark, but because the sorting option doesn't work I still have to manually select these values to remove them.

The picture below shows some of the resulting values after changing data sources, refreshing the count, and then sorting by count ascending.

Re: Unique value counts won't refresh correctly after changing layer's data source

DanielMatranga — Tue, 16 Aug 2016 16:46:19 GMT

Basically what you have found seems to be a #bug to me

That being said, I would try adding the new data source fresh, as in click Add Data > browse to the layer you want to add. Next, I would re-symbolize based on values.

When using Pro, if I try to change the data source without adding it again like I mentioned above, Pro usually just crashes and exits without warning. So do save often.

Re: Unique value counts won't refresh correctly after changing layer's data source

BrettGoodwin — Wed, 31 Aug 2016 14:03:33 GMT

Daniel, I agree that this seems like a bug.

Unfortunately re-symbolizing after adding a new layer will change the color/value assignments that I'm trying to maintain across numerous layers.

Re: Unique value counts won't refresh correctly after changing layer's data source

DanPatterson_Retired — Wed, 31 Aug 2016 14:11:47 GMT

save to a layer file, if you need to maintain symbology

Re: Unique value counts won't refresh correctly after changing layer's data source

BrettGoodwin — Wed, 31 Aug 2016 14:21:38 GMT

I'll still have the same issue as the original post, value counts won't refresh correctly.

Re: Unique value counts won't refresh correctly after changing layer's data source

JeremyWright — Wed, 21 Sep 2016 21:07:00 GMT

Brett,

Please report this issue to Esri Support, so they can get this assigned to the appropriate dev team.

regards,

Jeremy W.

Re: Unique value counts won't refresh correctly after changing layer's data source

RichardHowe — Fri, 14 Sep 2018 14:26:19 GMT

This bug still persists in 2.2 as far as I can tell. Why is their even the functionality for Pro to display a question mark in the count? It is surely an explicit numeric value! Either it is present or not?!

Re: Unique value counts won't refresh correctly after changing layer's data source

BrettGoodwin — Thu, 20 Sep 2018 14:20:15 GMT

Yep, the bug is still there. I spoke with ESRI at the last UC and then opened a case regarding the "?"s. They identified it as a bug, so hopefully we'll see it fixed soon!

Re: Unique value counts won't refresh correctly after changing layer's data source

RichardHowe — Fri, 21 Sep 2018 08:01:10 GMT

Brett, good to hear that they're addressing it. Nice work!

Re: Unique value counts won't refresh correctly after changing layer's data source

BrettGoodwin — Tue, 12 Mar 2019 15:04:58 GMT

Good news, as of Pro 2.3.1 this bug has been fixed. You can symbolize a layer by a unique value, change the data source or add a definition query to the layer, update the value counts to show the new counts, and sort them ascending or descending.

Re: Unique value counts won't refresh correctly after changing layer's data source

GIS_Spellblade — Wed, 30 Oct 2019 15:57:56 GMT

I'm running into this issue when dealing with an Arcade Expression; it works fine when using just attribute-based symbology from stock data sources-- --it does not work when using an Arcade Expression.

-- Edit --

I'm using a When() function to consolidate attributes to a more meaningful symbology.

Xander Bakker‌, do you know who would know about this? Or am I doing it wrong

Re: Unique value counts won't refresh correctly after changing layer's data source

XanderBakker — Sun, 03 Nov 2019 02:19:00 GMT

Hi gisspellblade ,

Can you share the expression that you are using and explain a bit more about your data?

Re: Unique value counts won't refresh correctly after changing layer's data source

GIS_Spellblade — Sat, 11 Dec 2021 15:10:15 GMT

Hi Xander Bakker‌,

Sorry for the slow response on my end, this is the expression that I am using within the Symbology tab:

WHEN(
$feature.CASE_STATUS == "Open - Founded", "Open",
$feature.CASE_STATUS == "Open - Pending", "Open",
"Closed")‍‍‍‍

This data is comprised of inspection case records with a possibility of 4 different statuses; however, for reporting purposes, I've been asked to show status as either open/closed. The above snippet changes two of the statuses to a singular: "open" and I rely on the default option to force the others into a "closed" status. When using an Arcade expression, the count data continues to show as a "?" but when using one of the regular columns the count feature works as intended. My band-aid solution was to manually count the records with a selection sort and then write that into the label.

Arcade1

Arcade2

Regular Column

Let me know what you think,

Re: Unique value counts won't refresh correctly after changing layer's data source

MichaelVolz — Wed, 06 Nov 2019 19:21:36 GMT

Are you by any chance processing EnerGov generated data through Pro?

Re: Unique value counts won't refresh correctly after changing layer's data source

GIS_Spellblade — Wed, 06 Nov 2019 19:41:26 GMT

Hi Michael Volz‌, this is EnerGov data. We're not generating anything through Pro, we are handling all of the EnerGov-to-GIS stuff through SQL queries and pushing that to our SDE.

Re: Unique value counts won't refresh correctly after changing layer's data source

XanderBakker — Thu, 07 Nov 2019 02:10:45 GMT

Hi gisspellblade ,

Can you share a screenshot of your data?

Re: Unique value counts won't refresh correctly after changing layer's data source

GIS_Spellblade — Thu, 07 Nov 2019 19:59:09 GMT

Hi Xander Bakker‌, here's what a sample of my data looks like. Let me know if you'd like anything further.

Re: Unique value counts won't refresh correctly after changing layer's data source

XanderBakker — Fri, 08 Nov 2019 12:37:16 GMT

Hi Jordan Carmona ,

I don't see anything strange in your data, the values are there and your expression is correct, The field does not have a domain defined (so you are not checking against domain codes). The only thing I can think off is that there might be an additional space or something that can break the expression.

Could you try this?

return Split($feature.CASE_STATUS, " ")[0];‍

It will split the text using the space and take the first element which should result in Open or Closed

Re: Unique value counts won't refresh correctly after changing layer's data source

GIS_Spellblade — Fri, 08 Nov 2019 17:29:11 GMT

Hi Xander Bakker‌,

I really like that!, definitely a much more elegant way of handling this. However, I still am not able to access features counts. I also exported this feature to a file geodatabase from our enterprise geodatabase and am still not able to access the counts using an Arcade expression.

Below is a screenshot of the new expression in our SDE.

Re: Unique value counts won't refresh correctly after changing layer's data source

XanderBakker — Fri, 08 Nov 2019 19:31:13 GMT

Hi Jordan Carmona ,

I see what you mean. I added the count based on an expression and initially it showed for a fraction of a second and after this it never showed again. I guess this could be a bug...