I have a dashboard that displays stats of roads within polygons that the user can select from a map. The issue is that some roads are on the border of 2 or more polygons. When I set up a layer action to spatially filter the road, the road will only show up for one of the polygons. My workaround was to use a 1:M join, so that there will be duplicates of roads for each polygon, and use a field filter instead of a spatial filter.
This works fine for just displaying the filtered roads. But if the user selects multiple polygons, the filtered stats in charts will include the duplicate roads, resulting in exaggerated stats.
Each road does have a unique ID, so duplicates will have the same ID. Is there any way to ensure that when a user selects a polygon, all roads intersecting it will be shown, but if they select multiple polygons duplicate roads will not be used for charts etc.?
