idea Support Statistics for data that is published from query layer in Developers Ideas

Support Statistics for data that is published from query layer

VytautasGipiskis — Fri, 25 Jan 2013 12:58:24 GMT

ArcGIS REST API allows to perform statistical functions on the Map service layers.
http://resources.arcgis.com/en/help/rest/apiref/index.html?featureserver.html
Layer resource contains supportsStatistics that indicates if the layer supports statistical functions in query operations and supportsAdvancedQueries to indicate if the layer supports orderBy in a query operation.

Awfully this functionality is limited to layers whose source is Geodatabase. I would like query layers to get this functionality as well. Query layers have huge advantage, when server side joins, computed colums are required.

Re: Support Statistics for data that is published from query layer

DamienO_Callaghan1 — Thu, 28 Mar 2013 01:24:18 GMT

This is required for using Query Layers via the Operational Dashboard as a number of the widgets require statistics to be enabled on the service.

Re: Support Statistics for data that is published from query layer

JackZHANG — Thu, 28 Mar 2013 01:31:15 GMT

Query layer is the one that can provide user flexibily of what tables they want to drive the statistics from. We need Queyr Layer supports statistics.

Re: Support Statistics for data that is published from query layer

FrankVeldhuis1 — Sun, 10 Nov 2013 19:01:58 GMT

I was having problems with the statistics tool until I came accross this idea. If a query layer is used the service doesn't return an error. This drove me nuts. At least give us a error/warning that stats are not supported on query layers.

Re: Support Statistics for data that is published from query layer

FabianoScardua — Thu, 20 Nov 2014 19:47:22 GMT

Query layer is the one that can provide user flexibily of what tables they want to drive the statistics from. We need Queyr Layer supports statistics.

Re: Support Statistics for data that is published from query layer

MichaelVolz — Thu, 01 Feb 2018 04:52:24 GMT

Can someone provide a simple example of a statistic call to a geodatabase layer through the REST endpoint?

I ask because it appears that I can use ORDER BY FIELDS in the REST endpoint page and it work on a standard geodatabase layer as well as a query layer. I can see the usefulness of statistics on a query layer for an Operations Dashboard so I would like to know if ORDER BY FIELDS is considered a statistic as it is working for me on a query layer REST call at 10.5.1.

Re: Support Statistics for data that is published from query layer

FabianoScardua — Thu, 01 Feb 2018 11:13:10 GMT

Statistics use a aggregation function

To test you need use the outStatistics and groupByFieldsForStatistics parameters from REST API

https://services.arcgis.com/A6pvCYPD0FSpq2rw/arcgis/rest/services/Trails/FeatureServer/0/query?where=1%3D1&objectIds=&ti…

Re: Support Statistics for data that is published from query layer

LSaunders — Tue, 15 May 2018 18:06:16 GMT

This needs to be added to make the new Operations Dashboard functional! Live data comes from all sorts of sources, query layers is one common one. Seems like oversight to me!