Latest Contributions by KenBuja

No, this shows the results of the one-line code. The two highlighted points show the Data field above and below 40 code.png   ... View more

It's at the bottom of your profile page ... View more

There's an updated version the AGO Assistant available at https://assistant.esri-ps.com/signin. The older version hasn't been updated in a few years. ... View more

The Count function cannot take a null, so you'll have to check if the Intersects function returns a null. var retail_layer = FeatureSetById($map, "18d1d756020-layer-70"); var radius = Buffer($feature,.75,"miles"); var result = Intersects(retail_layer, radius); if (IsEmpty(result)) return 'No features found'; var retail_count = Count(result); return retail_count; The second code worked as expected in my testing (changing the layer id and the field for the retail list) ... View more

In the FeatureSetByPortalItem function, you have to include the "Status" field on the fields parameter when getting the FeatureSet and you were missing a closing quote for the Digital_Co field. The Filter function uses a FeatureSet as an input. You also have to put quotes around your filter expression and the "in" operator uses parentheses, not brackets.   // Reference layer using the FeatureSetByPortalItem() function. var fs = FeatureSetByPortalItem(Portal('https://my-site.pr.portal'), 'b19q57894c8521f58e68t87412' , 0, ['Status', 'Printed_Co', 'Digital_Co'], false); var sumPrintedCo = Sum(Filter(fs, "Status in ('Complete/Delivered', 'Rdy for PickUp')), 'Printed_Co'); var sumDigitalCo = Sum(Filter(fs, "Status in ('Complete/Delivered', 'Rdy for PickUp')), 'DigitalCo'); sumPrintedCo + sumDigitalCo     ... View more

This isn't the most efficient code, so I can imagine it's slower with longer array lists. Since it has to make a query for each item in the list, multiple requests are sent back to the server. You might look at @jcarlson's blog about "memorizing" the table and see if that makes a measurable difference. You could also just read the table into a dictionary and use the code field as a key to get the URL value instead of using the Filter on the Table. ... View more

In my functions to run Geoprocessing tools, it's an async Task and uses await when calling the ExecuteToolAsync method. Here's an example of one of my functions that uses the Dissolve tool.   public static async Task<IGPResult> DissolveFeatures(FeatureClass featureClass, string DissolveFields, string StatsFields, string OutputName, GPExecuteToolFlags flags = GPExecuteToolFlags.None) { List<object> arguments = new() { featureClass, OutputName, DissolveFields, StatsFields }; IGPResult result = await Geoprocessing.ExecuteToolAsync("management.Dissolve", Geoprocessing.MakeValueArray(arguments.ToArray()), null, null, null, flags); return result; } //this is how I use the function and the returned result bool results = await QueuedTask.Run(async () => { //lots of code path = geodatabase.GetPath().AbsolutePath IGPResult DissolvedSummaryResult = await Utilities.DissolveFeatures(JoinFC, StrataFieldName, StatField, $"{path}\\JoinedPointDissolve", GPExecuteToolFlags.None); if (DissolvedSummaryResult.IsFailed) { // do something if it fails return false; } using FeatureClass DissolveSummaryFC = geodatabase.OpenDataset<FeatureClass>("JoinedPointDissolve"); //lots more code )};   I also notice you're not specifying the Toolbox where ExtractByMask is located in the tool path property. In my code, the tool is in the Data Management toolbox, so I call it using "management.Dissolve". If you look at the documentation for the tool you're using, in the Parameters section, you can see how it's called in Python. To use it in .NET, just remove "arcpy." python.png ... View more

Line 11 should look like this result = layer.FSA + " " + layer.LDU; ... View more

Glad to help. Don't forget to click the Accept as Solution button on the post that answered your question. ... View more

What type of field is "date_issued"? In your first post, it looks like it's a date field. If that's so, then you can't use a string to query it or to put in the result ('20240109A'). I successfully tested my code on a string field. ... View more