topic Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart in ArcGIS Dashboards Questions

Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

JustinPence2 — Mon, 29 Jul 2019 21:41:19 GMT

I am trying to create a serial chart, that shows the top rig operators. The layer is a hosted feature service, and contains individual points. My category field is Operator Name, and my statistic is count. The table will then display the number of rigs per operator name. However, when I try to sort by statistic, I get the error, "Cannot Access Data."

Again, this is a hosted feature service, and by looking at the metadata, statistics are enabled for this layer.

Ultimately, I would like a chart showing the top ten operators by Rig Count in a geographic area that updates as you zoom in/out in the map.

Update: I've tested this on ArcGIS Online, and have no issues running the same exact scenario. However, when I try in Portal 10.7, I can't sort by statistic. I assume I've encountered some type of bug

Any ideas?

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

LindsayMaier — Fri, 06 Dec 2019 20:04:07 GMT

I have the exact same problem. No idea what is going on. It was never a problem in ArcOnline, but in our Enterprise portal, it says "no data" -- it's driving me nuts!

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

JustinPence2 — Fri, 06 Dec 2019 20:18:33 GMT

After reporting the issue, they came back and were able to replicate the bug. According to the #BUG-000120535, it will be fixed in Enterprise 10.8.

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

LindsayMaier — Fri, 06 Dec 2019 20:21:37 GMT

Thanks so much for the heads up! Hopefully 10.8 comes sooner rather than later...

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

JustinPence2 — Fri, 06 Dec 2019 20:30:27 GMT

I know 10.8 is in the Pre-Release stage, so I assume it will be soon.

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

NathanielSimmons — Tue, 17 Dec 2019 19:32:27 GMT

I'm actually having this same problem as well, but it is on ArcGIS Online and not Enterprise... What I'm trying to do is even simpler than what you are describing. I just want to show the current number of features in a dashboard indicator, but I get the "cannot access data" message.

When configuring the indicator, if I click on "Show data table," all of the correct records show up. But when in "show preview" mode, it says "No Data" with that error message.

Over the years that I've used GIS, it always seems like it's the simplest/most basic tasks that won't work correctly...

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

MackenzieCarter — Wed, 22 Jul 2020 14:13:15 GMT

Still not working

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

NajyaBatool1 — Wed, 22 Jul 2020 19:13:41 GMT

Hi everyone. It does work in 10.8 - however in order for Portal to have access to the dataset to sort, it needs to be copied to server. In Pro, please choose to copy all data when publishing and it'll work!

Re: Can't Sort By Statistic Due To Cannot Access Data Error - Serial Chart

MorganTitus1 — Wed, 15 Sep 2021 21:35:43 GMT

Hi Najya,

When you say "Server" do you mean the Portal hosting server or can this be a non hosting ArcGIS Server? The latter is my case and in 10.8 the sorting by statistics still won't work. Thanks for any clarification you can provide!