Latest Contributions by KenBuja

If I understand how your fields are set up, give this a try: **Edited to fix an error (i.e. "$datapoint[tg]" instead of "$datapoint.tg")** var result = ""; if (!IsEmpty($datapoint.target)) { var targetArray = Split($datapoint.target, ",") 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]}`; } } return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { result } }     ... View more

Unfortunately, AGOL does not recognize the formatting tags used in ArcGIS Pro. If this for a popup, you can use an Arcade element with html tags like this var output = `This is <span style="color:red">red</span> text` return { type : 'text', text : output } which gives you a popup like this   ... View more

Can you just replace the underscore before you add it to the dictionary? for(var i in split_array) { var newSplit = Replace(split_array[i], '_', ' '); Push(choicesDict.features, {"attributes":{ "globalid": globalid, "Name": Name, "Jurisdiction": Jurisdiction, "Community": Sub_Jurisdiction, "core_capability": core_capability, "Target": Target, "split": Trim(newSplit)}}) }     ... View more

The DateAdd function expects the input date first, then the value to be added, then the units. The units have to be spelled out ("months" instead of "m"). This code checks if there is a date in the SurveyDay field, then adds the proper number of months.   if (!IsEmpty($feature.SurveyDay)) DateAdd($feature.SurveyDay, $feature.Reinspection_Period, 'months')     ... View more

Make sure you're getting features from the FeatureSet to get your attributes. Something like this: var pFS = yourParcelFeatureSet; var intersectedFS = Intersects(pFS, $feature); var feat = First(intersectedFS); //assuming there is just one feature in the interection results var owner = feat.OwnerAddress; var filteredFS = Filter(pFS, 'OwnerAddress = @owner'); var output = []; for (var f in filteredFS) { Push(output, ` ${f.ParcelID} `); } //this works for a Text element. Use <br> for an Arcade element return `${Count(filteredFS)} parcels: ${Concatenate(output, '')}` ... View more

A Data Expression needs to return a FeatureSet, not a variable. Replace line 11 with this var theDict = { 'fields': [{ 'name': 'result', 'type': 'esriFieldTypeInteger'}], 'geometryType': '', 'features': [ { 'attributes': { 'result': Text(Round(fiber_total),'#,####') } } ] }; return FeatureSet(theDict); ... View more

You have to set a variable to use with textColor. Also, Decode is a good replacement for if...else statements like this. var color = Decode($datapoint.event_type, 'Incident Activation', '#ADFF8C', 'Discussion-Based Exercise', '#FFC379', 'Operations-Based Exercise', '#71C1FD', '#FD7F7F') return { textColor: color, backgroundColor: '', separatorColor:'#adadad', selectionColor: '#fcfc86', selectionTextColor: '#fcfc86', // attributes: { // attribute1: '', // attribute2: '' // } }   ... View more

This will create a FeatureSet that contains the DateDiff calculation for each record. var fs = FeatureSetByPortalItem( portal, 9437842bc29b54b07993a9b6b3d63c0d1 0, ['*'], //or use the only the fields you want to include false ); var s = Schema(fs); //return s Push(s.fields, {'name':'CloseTime', 'alias': 'Close Time', 'type': 'esriFieldTypeDouble'}) var temp_dict = { fields: s['fields'], geometryType: '', features: [] } for (var f in fs) { console(f) var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } console(attrs) attrs['CloseTime'] = DateDiff(f.DateWoClosed, f.InitiateDate, 'hours') Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(Text(temp_dict))     ... View more