BUG-000169317 for ArcGIS Online

Numéro d’ID de bogue	BUG-000169317
Envoi	July 23, 2024
Dernière modification	October 14, 2024
S’applique à	ArcGIS Online
Version trouvée	June 2024
Système d’exploitation	Windows OS
Version du système d’exploitation	11.0 64 bit
Statut	As Designed

Informations supplémentaires

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.

Solution de contournement

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.