https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1327189#M8450 <P>The Advanced Formatting expression controls <STRONG>how</STRONG> the items are displayed, not <STRONG>which</STRONG> items are displayed.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JohannesLindner_0-1694427306368.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80283iB0155B2A79781B91/image-size/large?v=v2&amp;px=999" role="button" title="JohannesLindner_0-1694427306368.png" alt="JohannesLindner_0-1694427306368.png" /></span></P><P>&nbsp;</P><P>To do what you want, create a one-to-one view.</P><P>&nbsp;</P> Mon, 11 Sep 2023 10:15:57 GMT JohannesLindner 2023-09-11T10:15:57Z https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1327103#M8447 <P>I created a one-to-many join between a country polygon hosted feature layer and a contact point hosted feature layer.&nbsp; Wanting to create a list, in a dashboard, of all the countries where contacts were made, but I don't appear to have the Distinct expression written correctly...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JasonCyphers_0-1694340858182.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80271i698DBEA332797033/image-size/medium?v=v2&amp;px=400" role="button" title="JasonCyphers_0-1694340858182.png" alt="JasonCyphers_0-1694340858182.png" /></span></P><P>&nbsp;</P> Sun, 10 Sep 2023 10:38:29 GMT https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1327103#M8447 JasonCyphers 2023-09-10T10:38:29Z https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1327189#M8450 <P>The Advanced Formatting expression controls <STRONG>how</STRONG> the items are displayed, not <STRONG>which</STRONG> items are displayed.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JohannesLindner_0-1694427306368.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80283iB0155B2A79781B91/image-size/large?v=v2&amp;px=999" role="button" title="JohannesLindner_0-1694427306368.png" alt="JohannesLindner_0-1694427306368.png" /></span></P><P>&nbsp;</P><P>To do what you want, create a one-to-one view.</P><P>&nbsp;</P> Mon, 11 Sep 2023 10:15:57 GMT https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1327189#M8450 JohannesLindner 2023-09-11T10:15:57Z https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1329365#M8470 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/9918">@JasonCyphers</a>, try looking at the Grouped Values table type. Use Country as the Category field.&nbsp;</P> Sat, 16 Sep 2023 18:56:15 GMT https://community.esri.com/t5/arcgis-dashboards-questions/need-help-with-distinct-expression-in-dashboard/m-p/1329365#M8470 ChipMorgan65 2023-09-16T18:56:15Z