BUG-000169317 for ArcGIS Online

Número de ID del error	BUG-000169317
Enviado	July 23, 2024
Última modificación	October 14, 2024
Relacionado con	ArcGIS Online
Versión encontrada	June 2024
Sistema operativo	Windows OS
Versión de sistema operativo	11.0 64 bit
Estado	As Designed

Información adicional

The current implementation does not support the use of distinct count in combination with aggregation for fields other than those used in the statistics calculation. This behavior applies to both the Online and Enterprise feature services. Current Behavior: For non-aggregated queries, the documented behavior is correct. For aggregated queries with distinct count: The system always uses the statistics field as the distinct field. In the example provided, it is the population field. Out fields are only supported for aggregated queries if they are the group by fields. Explanation: The query structure in question presents challenges in interpretation and execution. After careful consideration and discussion with the Enterprise team, it is determined that supporting this specific use case would introduce significant complexity and potential risks to the system.

Solución alternativa

It is recommended for the users seeking to achieve similar results to follow the following approach: Use a group by clause on the desired fields (e.g., GROUP BY zipcode, population). Calculate the distinct sum for each group. If needed, infer the total sum from the grouped results. This method provides a more reliable and supported way to obtain the required information while maintaining system integrity and performance.