We have a dataset that contains unique ID records across multiple variables, with some variables delimited by semi-colons. We’d like one of the delimited variables used on a bar chart y-axis as well as in a Filter widget in Experience Builder. The Filter widget appears to be possible to configure using “contains” and “Predefined unique values”. Is some type of similar option available in the Chart widget to drive axis categories, and if not, is this on the Esri roadmap or is there some other way to achieve this? The additional challenge will be for the charts and statistics to display aggregated counts by default without double counting, while still being able to filter by the delimited variables. We’d like to try and avoid arcade; if needed, we could reformat the data to split out the delimited records into separate rows. However, I’m running into limitations trying to do this as well, given I don’t see a way for the charts to specify a unique count (which would be required to avoid double-counting in an instance where we split the data into separate rows) and when I try to expand the data to go across multiple fields for a “By field” with a “sum” approach, the chart filtering is including co-occurrences.
