I have 3 problems with Statistics:
A temporary service you can try this out on: REMOVED
1.) Statistics do not work with a version other than DEFAULT. So If I add a table in as version Office statistics do not work. If I add table in as version DEFAULT statistics do work. See Species_DEFAULT and Species_Office in map service above.
2.) If a versioned table is added to a feature service, it shows it supports statistics in the feature service but not in the map service. It in fact doesn't support then in either. I don't have a public example of this ATM.
3.) Statistics do not work with views. I create a view in the sde (SQL Express) via ArcCatalog and add it to a map service as version DEFAULT. Rest map service shows it supports statistics in both DEFAULT and Office versions but statistics do not work. See vInspectionsMosSites_Office and vInspectionsMosSites_DEFAULT in map service above.
A quick and easy statistic I am trying out:
Where: 1=1
Output Statistics:
[{
"statisticType":"count",
"onStatisticField":"*",
"outStatisticFieldName":"Count"
}]
Is there going to be support for versioned statistics in a future release? It would be a pain to be able to edit data and not see the changes in the statistics.
