https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-intersect-and-groupby/m-p/1282796#M7700 <P>Hello,&nbsp; I would like to create a dashboard data expression that combines a few dashboard data expression elements.&nbsp; &nbsp;I have a project buffer layer that I would like to intersect a Living Atlas layer.&nbsp; From the Living Atlas layer I would like to take an ordinal data field&nbsp;(e.g. good, better, best) and sum the occurrences.&nbsp; &nbsp;This way I can create a chart in my dashboard that is categorized by project buffer, per ordinal data field summed occurrences.&nbsp;</P><P>I am also wondering if this can order the ordinal data in the chart layout, because we cannot manually do this.&nbsp; And the data is coming from Living Atlas so I cannot create a custom order field.</P><P>My feature set dictionary should include Project Name and Buffer from my data,&nbsp; and sum attributes of ordinal data field attribute occurrences (good, better, best).</P><P>I have followed the online examples of spatial aggregation provided by Josh Carlson and scoured every article in this forum (and grateful for all of this), but I do not know how to add this additional wrinkle.&nbsp;</P><P>I think I need a GroupBy function, but not sure where.&nbsp;</P><P>Thanks in advance!&nbsp;</P> Wed, 26 Apr 2023 13:52:55 GMT BrianWamsley 2023-04-26T13:52:55Z https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-intersect-and-groupby/m-p/1282796#M7700 <P>Hello,&nbsp; I would like to create a dashboard data expression that combines a few dashboard data expression elements.&nbsp; &nbsp;I have a project buffer layer that I would like to intersect a Living Atlas layer.&nbsp; From the Living Atlas layer I would like to take an ordinal data field&nbsp;(e.g. good, better, best) and sum the occurrences.&nbsp; &nbsp;This way I can create a chart in my dashboard that is categorized by project buffer, per ordinal data field summed occurrences.&nbsp;</P><P>I am also wondering if this can order the ordinal data in the chart layout, because we cannot manually do this.&nbsp; And the data is coming from Living Atlas so I cannot create a custom order field.</P><P>My feature set dictionary should include Project Name and Buffer from my data,&nbsp; and sum attributes of ordinal data field attribute occurrences (good, better, best).</P><P>I have followed the online examples of spatial aggregation provided by Josh Carlson and scoured every article in this forum (and grateful for all of this), but I do not know how to add this additional wrinkle.&nbsp;</P><P>I think I need a GroupBy function, but not sure where.&nbsp;</P><P>Thanks in advance!&nbsp;</P> Wed, 26 Apr 2023 13:52:55 GMT https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-intersect-and-groupby/m-p/1282796#M7700 BrianWamsley 2023-04-26T13:52:55Z