https://community.esri.com/t5/arcgis-dashboards-questions/filter-out-duplicate-records/m-p/1295393#M7895 <P>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.</P><P>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.&nbsp;&nbsp;</P><P>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.?</P> Fri, 02 Jun 2023 15:00:48 GMT AJ_devaccount 2023-06-02T15:00:48Z https://community.esri.com/t5/arcgis-dashboards-questions/filter-out-duplicate-records/m-p/1295393#M7895 <P>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.</P><P>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.&nbsp;&nbsp;</P><P>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.?</P> Fri, 02 Jun 2023 15:00:48 GMT https://community.esri.com/t5/arcgis-dashboards-questions/filter-out-duplicate-records/m-p/1295393#M7895 AJ_devaccount 2023-06-02T15:00:48Z https://community.esri.com/t5/arcgis-dashboards-questions/filter-out-duplicate-records/m-p/1482178#M9721 <P>I have this same issue that can't be accounted for in Dashboards or webmap charts</P> Fri, 31 May 2024 17:51:54 GMT https://community.esri.com/t5/arcgis-dashboards-questions/filter-out-duplicate-records/m-p/1482178#M9721 ArmstKP 2024-05-31T17:51:54Z