Latest Contributions by KenBuja

Expects is more critical when the Arcade expression is used in Visualization and Labeling. From the documentation: In some profiles, such as Visualization and Labeling, apps only request the data attributes required for rendering each feature or label. You're getting the list of fields from the feature, which will contain all fields in the Popup profile. You can put some logic in there to skip fields you don't want to include for(var field in $feature){ if (field != 'Parking'){ if($feature[field] == "Yes"){ for(var s in sch.fields){ if(sch.fields[s].name == field){ Push(Yes, sch.fields[s].alias); break; } } } } }   ... View more

Your return at line 33 means the GroupBy function didn't run. This sample script gives the expected table. One thing I had to change to make it work properly is to have the fields in the Dictionary start with a string. var fs = FeatureSet( {"fields":[ {"alias":"Type","name":"Type","type":"esriFieldTypeString"}, {"alias":"Year","name":"Year","type":"esriFieldTypeInteger"}], "spatialReference":{"wkid":4326}, "geometryType":"", "features":[ {"geometry":'', "attributes":{"Type":'Apple',"Year":2022}}, {"geometry":'', "attributes":{"Type":'Apple',"Year":2022}}, {"geometry":'', "attributes":{"Type":'Banana',"Year":2023}}, {"geometry":'', "attributes":{"Type":'Pear',"Year":2024}}, ] } ); var yearDict = {'fields': [{'name':'Type', 'type':'esriFieldTypeString'}, {'name':'y2022', 'type':'esriFieldTypeInteger'}, {'name':'y2023', 'type':'esriFieldTypeInteger'}, {'name':'y2024', 'type':'esriFieldTypeInteger'}], 'geometryType': '', 'features': []}; for (var feature in fs) { var cat = feature['Type'] var yearone = Iif(feature['Year'] == 2022,1,null) var yeartwo = Iif(feature['Year'] == 2023,1,null) var yearthree = Iif(feature['Year'] == 2024,1,null) Push(yearDict.features, {"attributes": {"Type": cat, "y2022": yearone, "y2023": yeartwo, "y2024": yearthree}}) } var fs_dict = FeatureSet(Text(yearDict)); //return fs_dict return GroupBy(fs_dict, ['Type'], [{ name: '2022', expression: 'y2022', statistic: 'Count' }, { name: '2023', expression: 'y2023', statistic: 'Count' }, { name: '2024', expression: 'y2024', statistic: 'Count' }]);     ... View more

You're missing the layerid in line 3 ... View more

A little explanation of what my code is doing. It makes the array of targets and loops through them. The variable i is a number representing the position of the element in the array, so it will be 0 for the first loop, 1 for the second loop, and so on. That number gets tacked on the end of the field name if the number isn't equal to zero with this IIf function var tg = iif(i > 0, `target_goal_${i}`, 'target_goal')     Unfortunately, you're adding more complexity to this. Looking at the data, the employment fields are only going to be added for the targets "Short_Term_Unemployed_and_Underemployed" and "Long_Term_Unemployed_and_Underemployed. Also, the "Situational_Briefings" target uses a different naming convention. So this code searches for those cases and gets the fields differently. var cap_target_text = Replace($datapoint.target, '_', ' ') var result = ""; if (!IsEmpty(cap_target_text)) { var targetArray = Split(cap_target_text, ",") for (var i in targetArray) { result += `<br><br><span style="color:#ffffbe"><i>Target: </i></span> ${Trim(targetArray[i])}`; var tg = iif(i > 0, `target_goal_${i}`, 'target_goal') if (!IsEmpty($datapoint[tg])) result += `<br><br><span style="color:#ffffbe"><i>Target Goal: </i></span>${$datapoint[tg]}`; var tv = iif(i > 0, `target_value_${i}`, 'target_value') if (!IsEmpty($datapoint[tv])) result += `<br><br><span style="color:#ffffbe"><i>Target Value: </i></span>${$datapoint[tv]}`; var gv = iif(i > 0, `gap_value_${i}`, 'gap_value') if (!IsEmpty($datapoint[gv])) result += `<br><br><span style="color:#ffffbe"><i>Gap Value: </i></span>${$datapoint[gv]}`; var gp = iif(i > 0, `gap_percent_${i}`, 'gap_percent') if (!IsEmpty($datapoint[gp])) result += `<br><br><span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>${$datapoint[gp]}%`; if (Find('Unemployed', targetArray[i]) > -1) { var unemploy_tg = iif(i > 0, `unemploy_target_goal_${i}`, 'unemploy_target_goal') if (!IsEmpty($datapoint[unemploy_tg])) result += `<br><br><span style="color:#ffffbe"><i>Target Goal: </i></span>${$datapoint[unemploy_tg]}`; var unemploy_tv = iif(i > 0, `unemploy_target_value_${i}`, 'unemploy_target_value') if (!IsEmpty($datapoint[unemploy_tv])) result += `<br><br><span style="color:#ffffbe"><i>Target Value: </i></span>${$datapoint[unemploy_tv]}`; var unemploy_gv = iif(i > 0, `unemploy_gap_value_${i}`, 'unemploy_gap_value') if (!IsEmpty($datapoint[unemploy_gv])) result += `<br><br><span style="color:#ffffbe"><i>Gap Value: </i></span>${$datapoint[unemploy_gv]}`; var unemploy_gp = iif(i > 0, `unemploy_gap_percent_${i}`, 'unemploy_gap_percent') if (!IsEmpty($datapoint[unemploy_gp])) result += `<br><br><span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>${$datapoint[unemploy_gp]}%`; } if (targetArray[i] == 'Situational_Briefings'){ if (!IsEmpty($datapoint.sb_target_goal_5)) result += `<br><br><span style="color:#ffffbe"><i>Target Goal: </i></span>${$datapoint.sb_target_goal_5}`; if (!IsEmpty($datapoint.target_value_numeric_5)) result += `<br><br><span style="color:#ffffbe"><i>Target Value: </i></span>${$datapoint.target_value_numeric_5}`; if (!IsEmpty($datapoint.sb_gap_value_5)) result += `<br><br><span style="color:#ffffbe"><i>Gap Value: </i></span>${$datapoint.sb_gap_value_5}`; if (!IsEmpty($datapoint.sb_gap_percent_5)) result += `<br><br><span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>${$datapoint.sb_gap_percent_5}`; } } } return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { result } }   ... View more