Latest Contributions by KenBuja

You can use the GroupBy function to calculate this var fs = FeatureSetByPortalItem( Portal("https://www.arcgis.com"), "yourID", 0, ['County','Year', 'curr_enr','prev_enr'], false ) GroupBy(fs, ['County','Year','curr_enr','prev_enr'], {name: 'Change', expression: '(curr_enr - prev_enr)/prev_enr', statistic: 'Max'}) ... View more

Also note that you can make the When statement more concise var tod = When(hour >= 0 && hour <= 5, "Night", hour <= 8, "Morning", hour <= 15, "Day", hour <= 23, "Evening", Null ); ... View more

Are you viewing this in Firefox? There have been reports of some issues with Firefox v145.0 That said, I'm seeing the Preview button on my machine using ExB DE 1.18 in both Firefox and Chrome. ... View more

You can write a function that returns the color for the attribute passed in as a parameter. function bgColor(attribute) { when (attribute <= 70, "red", attribute <= 80, "orange", attribute <= 90, "yellow", attribute <= 95, "green", "blue") } //in use var theColor = bgColor($feature.attribute)   ... View more

I guess I'm not clear on the number you're expecting to get for the total area. Do you want to sum up the area of the portion of each lake that intersect the each tract? If so, then you'll have to loop through each tract and each lake to get the Intersection geometry and add its area to the total. However, the total count of the lakes will likely be incorrect, since a lake intersecting several tracts will be counted for each tract. ... View more

I've tested the code using some of my own data and it returned the expected data. I did make a change to line 17 to use the field type "esriFieldTypeInteger" since Count returns an integer, but keeping it as it is also works. The next step would be to put some debugging Console messages in the code at various places (like before and after line 11) and click the Run button in the editor window. This will give you a better idea where the code is crashing. ... View more

Doing lots of intersects is a resource hog, since the code has to make external calls for each feature in the loop. @jcarlson wrote a good post about how to store the features in memory (using his Memorize function) to speed up this process. This would be good if you wanted to create a table showing how many lakes are in each tract. However, since you're looking to just get the sum off all the lakes in all the tracts, you can loop through the tracts FeatureSet to union them into a single feature, then use that feature in your Intersects function. You can get the count of that FeatureSet to see how many lakes there are and use the Area function to get the total area of all the lakes. var port = Portal("https://www.arcgis.com"); // Load layers with correct area field name var tracts = FeatureSetByPortalItem(port, "b9fcbedac0384e32bc3dba6aec1a8cf6", 0, ["OBJECTID"], true); var lakes = FeatureSetByPortalItem(port, "5564b2e702364aefba08df8c95216a1f", 0, ["OBJECTID"], true); var arrTracts = []; for (var tract in tracts) { Push(arrTracts, tract); } var lakesFS = Intersects(lakes, Union(arrTracts)); return FeatureSet( { fields: [ { name: "LakeCount", type: "esriFieldTypeSingle" }, { name: "Acres", type: "esriFieldTypeDouble" } ], features: [ { attributes: { LakeCount: Count(lakesFS), Acres: Area(lakesFS, "acres") } } ] } );   ... View more

You should start a new discussion when asking a question like this. Also, when posting code, use the "Insert/Edit code sample" button. It makes it easier to read and refer to specific lines. There are several problems in this line. var countLakes = Count(Filter(lakes, Intersects(Geometry(lakes), tractGeom))); You don't need to filter the results of the Intersects function and even if you did need it, you weren't providing the required sqlExpression. The Geometry function takes a feature as an input instead of a FeatureSet. And in the previous line, you don't need to cast t as a Geometry. Try this instead var countLakes = Count(Intersects(lakes, t)); ... View more

You can use the SQL CASE statement in the first GroupBy to bin the ages. This will also calculate the age group for the current year instead of 2025. The second GroupBy will count the number of each of the age groups var fs = FeatureSetByPortalItem( Portal('https://www.arcgis.com/'), '123456', 0, ['year_of_birth_please_write_full'], false ); var sql = `Case When year_of_birth_please_write_full > ${Year(Now()) - 18} Then '<18' When year_of_birth_please_write_full > ${Year(Now()) - 30} Then '18-30' When year_of_birth_please_write_full > ${Year(Now()) - 40} Then '31-40' When year_of_birth_please_write_full > ${Year(Now()) - 50} Then '41-50' When year_of_birth_please_write_full > ${Year(Now()) - 60} Then '51-60' else '>60' end` ; var grouped = GroupBy( fs, 'OBJECTID', // unique ID field { name: 'Age_years', expression: sql, statistic: 'MAX' } ); GroupBy( grouped, "Age_years", { name: "Age_Groups", expression: "1", statistic: "COUNT" } );   ... View more