https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130740#M5634 <P>Thank you! worked out</P> Wed, 05 Jan 2022 10:35:49 GMT SayedWali 2022-01-05T10:35:49Z https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130696#M5628 <P>Using the&nbsp;<STRONG>List Element</STRONG> I am taking multiple layers and out of that, I am going to count the number of reportIDs per Province to know how many monitoring visits were carried out in each province. But looks like it doesn't count properly and the province is not listed uniquely. With my very light knowledge of Arcade I can't figure it out, any help will be appreciated:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SayedWali_0-1641361325751.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/30800i2F44FE0F9A96240A/image-size/medium?v=v2&amp;px=400" role="button" title="SayedWali_0-1641361325751.png" alt="SayedWali_0-1641361325751.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="c">var portal = Portal('https://www.arcgis.com/'); // Group by province // Count report IDs var HMAFAR = GroupBy( FeatureSetByPortalItem(portal,'56db417ebbc541bcbb6ccf9c49524cc9',0,['*'],false), ['province'], [ { name: 'FAR_ID', expression: 'rpt_id', statistic: 'COUNT' }, ], ); var HMAPDIA = GroupBy( FeatureSetByPortalItem(portal,'cd991db8686d4d0b8c9a6c0e910f03ab',0,['*'],false), ['field_8'], [ { name: 'PDIA_ID', expression: 'field_1', statistic: 'COUNT' }, ] ); var MRE = GroupBy( FeatureSetByPortalItem(portal,'3e63815f693a4d0888209d58ebe7fe8b',0,['*'],false), ['field_8'], [{ name: 'MRE_ID', expression: 'field_1', statistic: 'COUNT' }, ] ); var NTS = GroupBy( FeatureSetByPortalItem(portal,'30b595fc7ef64bb596bebcbbffb68db6',0,['*'],false), ['province'], [ { name: 'NTS_ID', expression: 'repid', statistic: 'COUNT' }, ] ); var FHMAML = GroupBy( FeatureSetByPortalItem(portal,'4861c1d8d407434193a012b504b69b36',0,['*'],false), ['field_8'], [ { name: 'HMAML_ID', expression: 'field_1', statistic: 'COUNT' }, ] ); var HMAML = filter(FHMAML, "ml_type = 'HMA ML'"); var VA = GroupBy( FeatureSetByPortalItem(portal,'fbaf2ac4f8bc413c8770f7aaf4e77c4d',0,['*'],false), ['province'], [ { name: 'VA_ID', expression: 'rpt_id', statistic: 'COUNT' }, ] ); var layersDict = { fields: [ { name: 'Reports_Type', type: 'esriFieldTypeString' }, { name: 'count_of_ids', type: 'esriFieldTypeInteger' }, { name: 'provinces', type: 'esriFieldTypeString'}, ], geometryType: '', features: [], }; // Loop through each of the six FeatureSets and store attributes into a combined dictionary. var i = 0; for (var f in HMAFAR) { layersDict.features[i] = { attributes: { Reports_Type: 'HMAFAR', count_of_ids: sum(f['FAR_ID']), provinces: f['province'], }, }; i++; } for (var p in HMAPDIA) { layersDict.features[i] = { attributes: { Reports_Type: 'HMAPDIA', count_of_ids: sum(p['PDIA_ID']), provinces: p['field_8'], }, }; i++; } for (var m in MRE) { layersDict.features[i] = { attributes: { Reports_Type: 'MRE', count_of_ids: sum(m['MRE_ID']), provinces: m['field_8'], }, }; i++; } for (var n in NTS) { layersDict.features[i] = { attributes: { Reports_Type: 'NTS', count_of_ids: sum(n['NTS_ID']), provinces: n['province'], }, }; i++; } for (var ml in HMAML) { layersDict.features[i] = { attributes: { Reports_Type: 'HMAML', count_of_ids: sum(ml['HMAML_ID']), provinces: ml['field_8'], }, }; i++; } for (var v in VA) { layersDict.features[i] = { attributes: { Reports_Type: 'VA', count_of_ids: sum(v['VA_ID']), provinces: v['province'], }, }; i++; } // Return dictionary return FeatureSet(Text(layersDict));</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Wed, 05 Jan 2022 05:55:04 GMT https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130696#M5628 SayedWali 2022-01-05T05:55:04Z https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130724#M5632 <P>You have to do a final GroupBy on layersDict to get the sum of all counts.</P><P>&nbsp;</P><LI-CODE lang="javascript">// do a final GroupBy to add all reports in each province var layers_fs = FeatureSet(Text(layersDict)) return GroupBy( layers_fs, ['provinces'], {name: 'TotalReportCount', expression: 'count_of_ids', statistic: 'SUM'} )</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Wed, 05 Jan 2022 09:29:15 GMT https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130724#M5632 JohannesLindner 2022-01-05T09:29:15Z https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130740#M5634 <P>Thank you! worked out</P> Wed, 05 Jan 2022 10:35:49 GMT https://community.esri.com/t5/arcgis-dashboards-questions/distinct-count-issue-using-list-element/m-p/1130740#M5634 SayedWali 2022-01-05T10:35:49Z