We request the ability to concatenate multiple fields when creating expressions in the Group Filter widget’s SQL Expression Builder within ArcGIS Experience Builder.
Currently, it only supports selecting a single field. However, in many real-world cases, unique filtering requires the combination of multiple fields — for example, DISTRICT_ID + '_' + CAMERA_ID.
Use Case:
We are working on a dashboard where camera IDs are repeated across districts. To correctly filter and display the data, we need to combine the district and camera ID values before applying the filter. As we don't have accesses to the feature data.
Proposed Enhancement:
Support virtual fields or expression builders that allow field concatenation.
Enable comparing these concatenated values against those from another table or selection.
Allow this within the "Operator & Value" panel of the Group Filter configuration.
Business Impact:
This would reduce the need for preprocessing data outside of the app, enable more accurate filtering, and enhance usability in enterprise-scale dashboards.
