https://community.esri.com/t5/arcgis-dashboards-questions/groupby-null-date-and-not-null-date-pie-chart/m-p/1266658#M7473 <P>I'm not great with Arcade and stumped.&nbsp; I'm trying to create a pie chart in a Dashboard based on two date fields, 'Ordered' and 'Received'.&nbsp; Records are either null or populated with the date ordered or received.&nbsp; I'd like the pie chart to show counts of Ordered and Received.&nbsp; I think I need to use the GroupBy function, but I'm not sure what I'm doing.&nbsp; Thanks.</P><P>&nbsp;</P><LI-CODE lang="c">var p = &lt;portal&gt;; var tracts = FeatureSetByPortalItem(Portal(p),&lt;item&gt;, &lt;id&gt;, [ 'OBJECTID', 'Name', ‘Ordered', 'Received', ], false ); var count = GroupBy(tracts, [ // fields/expressions to group statistics by { name: ‘Ordered', expression: 'Received IS NOT NULL'}, { name: ‘Received', expression: 'Received IS NULL'} ], [ {name: 'Ordered', expression: '1', statistic: 'COUNT'} ]); return(count)</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Fri, 10 Mar 2023 20:11:17 GMT JustinWolff 2023-03-10T20:11:17Z https://community.esri.com/t5/arcgis-dashboards-questions/groupby-null-date-and-not-null-date-pie-chart/m-p/1266658#M7473 <P>I'm not great with Arcade and stumped.&nbsp; I'm trying to create a pie chart in a Dashboard based on two date fields, 'Ordered' and 'Received'.&nbsp; Records are either null or populated with the date ordered or received.&nbsp; I'd like the pie chart to show counts of Ordered and Received.&nbsp; I think I need to use the GroupBy function, but I'm not sure what I'm doing.&nbsp; Thanks.</P><P>&nbsp;</P><LI-CODE lang="c">var p = &lt;portal&gt;; var tracts = FeatureSetByPortalItem(Portal(p),&lt;item&gt;, &lt;id&gt;, [ 'OBJECTID', 'Name', ‘Ordered', 'Received', ], false ); var count = GroupBy(tracts, [ // fields/expressions to group statistics by { name: ‘Ordered', expression: 'Received IS NOT NULL'}, { name: ‘Received', expression: 'Received IS NULL'} ], [ {name: 'Ordered', expression: '1', statistic: 'COUNT'} ]); return(count)</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Fri, 10 Mar 2023 20:11:17 GMT https://community.esri.com/t5/arcgis-dashboards-questions/groupby-null-date-and-not-null-date-pie-chart/m-p/1266658#M7473 JustinWolff 2023-03-10T20:11:17Z