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!
I fixed this issue by disabling and then re-enabling archiving on my feature class and then overwriting my service. I work with oracle 11G and AGS 10.7.1
So, after more tests, it seems that the issue arises if the feature class is not organically created in the sde database. If you create the layer based on an imported shapefile, the indicator count issue seems to be incorrect.
However, the issue was resolved after copying the data from the current sde database to another sde database, and then importing it back into the original sde database (as a new layer).
Contrary to my previous post, it seems like the database platform was not really the issue. Copying the feature class out and bringing it back in seemed to reset the schema and it also avoided the strange bugs that occurred previously. You should give that a try and see if it works since it did for us.
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.
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.
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.
I am having the same issue as well. Has there been a solution found yet? This really needs resolved ESRI...
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?
Hi, were having exactly the exact same problem, did you find any solution to this?
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?
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
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
The outStatistics query of MapServer returns incorrect results when the dataset is non-versioned archived data.
mark
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
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.
Abdul: Can you tell if there are edits features in your SDE business table that are being included in the indicator count?
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>
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!
Abdul:
Is your data coming from SDE where the business table can have a different number of records than from layers feature count?
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.
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!
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.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
