I'm building a dashboard-like app in Experience Builder and want to utilize the gauge-style chart widget to better display progress for managing phosphorus in certain watersheds. I can only set the guide ranges to fixed values, which is fine if I'm only showing the sum of managed phosphorus for all watersheds but the gauge responds dynamically to selected watersheds, so those fixed values won't adjust to the watershed.
The widget should allow for dynamic display and have the option to set the guide percentages of a field so I can show a guide from 0-25%, 25-50%, 50-75%, 100%+ phosphorus managed of total expected amount when either no features are selected (shows sum for all records) or when a user makes a selection for a single watershed (shows value for that particular record.
Example of guide settings when a watershed isn't selected (shows all)

Example of guides when a selection is applied for a single watershed
