I have a long form data set where each feature represents someone seeking assistance with maternal health issues. Each feature has a date and multiple other attributes (around 20) associated with it. (ex: prefer English, prefer Spanish, seeking assistance with X,Y, or Z, referred by WIC). I have converted each attribute so its value is a 1 or 0 rather than text fields like yes/no. They are currently represented geographically as polygons in the form of "City,Zip". Table example attached.
I'm working in Enterprise 11.5.
I am trying to create a dynamic display in Experience Builder that allows the following:
-the user can select a date range and
-the user can select for any combination of attributes (or none) and the display will change dynamically to show a choropleth type display of City,Zip geometry that is the sum of the filtered attributes within the specified date range.
So for example, if I selected Jan2025-March2025 as my date and attributes where its value is > 0 for "prefer Spanish", seeking assistance with childcare, "seeking assistance with childproofing home", and "referred by WIC", I would get a map display of the summed value for every City,Zip polygon that meets this criteria. But I could then remove the filter for 'referred by WIC" and the sum would recalculate without that attribute.
I am trying to avoid creating a field for every attribute combination for every City,Zip because that would be... many hundreds of fields. Unless there is a way to do this through automation?
Anyway, what are folks suggestions on the best way to accomplish this, or is it too overly complicated/impossible to get done?
I've been researching solutions involving a relate table with a field that is overwritten with a new sum value based on the filtered attributes and date, but I couldn't figure this out.
Any help is greatly appreciated.
