I have a dashboard that has numerous indicators and gauges. When use one of the filters the map and all elements change. My problem is that i have the gauges are being calculated map layers entire dataset instead of the filtered subset.
specifics:
Map is showing 6 counties of Bridge Conditions (Good/Fair/Poor). I have an indicator and gauge for each condition. When no filters are applied all elements show correct values. When I apply a filter the indicator values change and reflect the correct filtered value. The gauges are always being calculated for the entire 6 county dataset.
example: All Counties Bridges = 299 // All Counties Poor Bridges = 101 so Gauge shows 34% ((101/299)*100)
When I apply a single County Filter - Total Bridges =51 // Poor Bridges = 10; I want the gauge to shows ~19.6% but it calcs the percentage to be ~3.3% ((CountyFilteredSubset / AllCountiesTotal#)*100) ((10/299)*100))
Appreciate any assistance.
Regards
