topic Re: Indicator in Operations Dashboard Showing Incorrect Count in ArcGIS Dashboards Questions

Indicator in Operations Dashboard Showing Incorrect Count

ISP_graynic — Wed, 21 Mar 2018 19:24:02 GMT

I am trying to create an indicator in the new Operations Dashboard and want to have it display the count of my features. When I do so however, it gives an incorrect number. The layer should have 42 features (and it even shows that if you open the table when creating the indicator), however when I actually create the indicator it shows 143 features. Does anyone have any ideas why it's giving me a wrong count when it should say 42 instead of 143?

Thanks!

Re: Indicator in Operations Dashboard Showing Incorrect Count

KevinSharkey — Thu, 05 Apr 2018 12:10:33 GMT

I have a similar problem where my layer reports a count of 509 features everywhere except in Operations Dashboard where it reports a count of 524.

I created a secure feature map service on our ArcGIS Server site and I consume this from within ArcGIS Online after adding it as a Feature Layer (to store credentials). ArcGIS Online confirms the feature count at 509 in the Map Viewer and the data tab in View item details etc.

The underlying feature class is non-versioned with archiving enabled within the enterprise geodatabase. Coincidentally, the business table has 524 rows, whereas the related view (business table name with suffix _evw) has 509 rows. My conclusion is, therefore, that the Operations Dashboard is incorrectly including edits. I haven't found a way to prevent this yet.

Re: Indicator in Operations Dashboard Showing Incorrect Count

ISP_graynic — Thu, 05 Apr 2018 14:31:50 GMT

I have an open case with tech support. I will let them know about your post so that can add it to the case and check and see if that's what the issue is. Thanks Kevin!

Re: Indicator in Operations Dashboard Showing Incorrect Count

AbdulJabbar1 — Fri, 13 Apr 2018 16:14:21 GMT

I have a very similar issue with feature count. It comes in Pie Chart and Indicator both. Please take a quick look at the screenshot attached.

Any assistance regarding this will be highly appreciated.

Thanks

Re: Indicator in Operations Dashboard Showing Incorrect Count

MichaelVolz — Wed, 18 Apr 2018 17:28:32 GMT

Abdul:

Is your data coming from SDE where the business table can have a different number of records than from layers feature count?

Re: Indicator in Operations Dashboard Showing Incorrect Count

ISP_graynic — Wed, 18 Apr 2018 19:39:30 GMT

After some time with ESRI, we think we found the issue. For my layer, there were attachments as well as a related table. When I removed the attachments and the related table in the SDE, the Indicator showed the correct number. For some reason the Count in the Indicator must have been counting either the attachments or some of the related records.

Hope this helps!

Re: Indicator in Operations Dashboard Showing Incorrect Count

AbdulJabbar1 — Wed, 18 Apr 2018 21:16:54 GMT

Hi Michael,

Thanks for responding to my query.

Yes you are spot on, my feature layer is coming from SDE (ArcGIS 10.3). I see everything alright till making web map in ArcGIS Online. However, when I utilised that layer in Operations Dashboard it gave me the incorrect number after setting up Indicator and Pie Chart.

Hope it makes more sense now.

Thanks

Abdul

Get Outlook for Android<https://aka.ms/ghei36>

Re: Indicator in Operations Dashboard Showing Incorrect Count

MichaelVolz — Wed, 18 Apr 2018 21:39:56 GMT

Abdul: Can you tell if there are edits features in your SDE business table that are being included in the indicator count?

Re: Indicator in Operations Dashboard Showing Incorrect Count

AbdulJabbar1 — Thu, 19 Apr 2018 08:13:46 GMT

Hi Michael,

Yes, the layer ''actually layers'' are being edited in the field using Collector on regular basis.

Re: Indicator in Operations Dashboard Showing Incorrect Count

MarkChilcott — Thu, 13 Sep 2018 04:32:55 GMT

Hi Peoples,

We are seeing the indicators and gauges showing the incorrect count values.

As with Kevin we created a secure feature map service on our ArcGIS Server site and we consume this from within ArcGIS Online after adding it as a Feature Layer (to store credentials). The underlying feature class is non-versioned with archiving enabled within the enterprise geodatabase.

The count being returned is the total number of rows in the table, including the archived values, which is clearly incorrect.

We have logged this as a support call. Will get back if we discover anything.

Cheers,

Mark

Re: Indicator in Operations Dashboard Showing Incorrect Count

WilliamPelchat — Fri, 21 Sep 2018 19:07:47 GMT

This is still happening last I tested it on 9/21/2018! Looks like any feature class with attachments is counted wrong, may also be including related features. Indicator widget is unusable for us in the dashboards for most of our applications because of this since we use related classes and most have attachments. This in using AGO and we host our own services on a public AGS.

As mentioned previously, the table count is correct on show preview

Re: Indicator in Operations Dashboard Showing Incorrect Count

MarkChilcott — Tue, 25 Sep 2018 04:35:06 GMT

Hi Peoples,

We logged the issue with ESRI support and in our particular case it was related to the following bug - which has been resolved in the 10.4 release. The analyst was not able to reproduce in 10.6.1.

Bug BUG-000089257

Synopsis

The outStatistics query of MapServer returns incorrect results when the dataset is non-versioned archived data.

Cheers,

mark

Re: Indicator in Operations Dashboard Showing Incorrect Count

MarkChilcott — Tue, 09 Oct 2018 23:05:49 GMT

Hi Peoples,

Quick follow up - Upgraded to ArcGIS Server 10.6.1 and the issue is resolved.

The issue is in the ArcGIS REST Service layers (not the database tier - we are still on ArcSDE 10.3.1).

Cheers,

Mark

Re: Indicator in Operations Dashboard Showing Incorrect Count

Brettmartin4 — Tue, 12 Mar 2019 19:07:47 GMT

We are at 10.6.1 and this is still an issue. I have attachments that I require for this workflow. This should be a very basic query. Filter widget in WAB has no problem with this same data. Can anyone provide a solution that does not involve removing attachments?

Re: Indicator in Operations Dashboard Showing Incorrect Count

SSMIC3038 — Wed, 14 Aug 2019 18:06:17 GMT

Hi, were having exactly the exact same problem, did you find any solution to this?

Re: Indicator in Operations Dashboard Showing Incorrect Count

AndreaBefus — Thu, 15 Aug 2019 21:09:38 GMT

I am having the same issue. I have a layer with attachments and a related table and the indicator is still showing the wrong number. Anyone have a solution where we don't have to disable attachments?

Re: Indicator in Operations Dashboard Showing Incorrect Count

NathanielSimmons — Fri, 03 Jan 2020 19:26:08 GMT

I am having the same issue as well. Has there been a solution found yet? This really needs resolved ESRI...

Re: Indicator in Operations Dashboard Showing Incorrect Count

NathanielSimmons — Mon, 06 Jan 2020 16:18:34 GMT

Andrea,

I'm not sure if you are still having this issue, but I found a work-around. I was trying to display a count for a feature (with attachments) published through a PostgresSQL database, which seems to have been the problem. After publishing the feature to an SQL Server database, the indicator displayed the correct number of features, even with the attachments enabled!!

Depending on the situation, creating a new database just to get the indicator to display the correct feature count hardly seems like a reasonable work-around. But, I wanted to let anyone who is having the same issue know about possible fix... This still needs looked at by ESRI though.

Re: Indicator in Operations Dashboard Showing Incorrect Count

AndreaBefus — Mon, 06 Jan 2020 17:15:19 GMT

Thank you for sharing your workaround. Unfortunately this layer has to be housed on an Oracle database where all of the other data is located.

Re: Indicator in Operations Dashboard Showing Incorrect Count

BrettMartin1 — Wed, 08 Jan 2020 12:18:28 GMT

I posted the original post with another account. Sorry for the delay. However, my layer is housed in a Oracle database. I was never able to get the Dashboard counts to be correct with the service published off default. However, I was able to get the correct counts with a service published off a version. The dashboard is used to monitor complaints, so pulling from the editing version gives our management a real time view. This was not my original plan, but works. We do have another service published off default with attachments in our organization that experienced the same count issues in the dashboard. Somehow theirs worked fine after a few days. I'm at a loss for an explanation. We did verify in testing that after the database is compressed the counts are corrected in all cases. Hope this helps.