https://community.esri.com/t5/arcgis-dashboards-questions/how-to-use-distinct-values-in-a-table/m-p/1524364#M10171 <P>We use Workflow Manager for Server and our workflow has several extended properties, including a 1-M relation.&nbsp; This generates redundant records depending on that 1-M relationship (ex. 1 job with 3 values in the extended properties table = 3 records in the jobs view table).&nbsp; We haven't figure out how to make sure that jobs records are distinct values because that option is not always available for configuration.</P><UL><LI>Why the distinct setting is not available when configuring your table in dashboard?</LI><LI>If I create a data expression...can you make sure just distinct jobs records are used (need several fields of my view table so I haven't been able to use groupby)?</LI></UL><P>Any help or suggestions are appreciated.&nbsp;&nbsp;</P> Tue, 20 Aug 2024 13:40:15 GMT Ulises 2024-08-20T13:40:15Z https://community.esri.com/t5/arcgis-dashboards-questions/how-to-use-distinct-values-in-a-table/m-p/1524364#M10171 <P>We use Workflow Manager for Server and our workflow has several extended properties, including a 1-M relation.&nbsp; This generates redundant records depending on that 1-M relationship (ex. 1 job with 3 values in the extended properties table = 3 records in the jobs view table).&nbsp; We haven't figure out how to make sure that jobs records are distinct values because that option is not always available for configuration.</P><UL><LI>Why the distinct setting is not available when configuring your table in dashboard?</LI><LI>If I create a data expression...can you make sure just distinct jobs records are used (need several fields of my view table so I haven't been able to use groupby)?</LI></UL><P>Any help or suggestions are appreciated.&nbsp;&nbsp;</P> Tue, 20 Aug 2024 13:40:15 GMT https://community.esri.com/t5/arcgis-dashboards-questions/how-to-use-distinct-values-in-a-table/m-p/1524364#M10171 Ulises 2024-08-20T13:40:15Z