Latest Contributions by jcarlson

Makes sense. Well, if a Data Expression is an option, you can probably get it to work. There are a couple of approaches people use, but first, get your features:   var fs = FeatureSetByPortalItem( Portal('your portal url'), 'itemid of your service', 0, // layer index of the feature layer ['objectid', 'Inspection_Date'], false )    A common approach from here is to loop through the entire FeatureSet, check the date field, and push features to an output FeatureSet with a new category field in place. By including the objectid, the resulting data can still be used to filter the rest of the dashboard. It will work, and it's easy to work with Arcade's built-in Date functions. But if you have a lot of features, this can take a lot of time to evaluate.   var out_dict = { fields: [ {name: objectid, type: 'esriFieldTypeOID'}, {name: inspection_complete, type: 'esriFieldTypeString'} ], geometryType: '', features: [] } var threshold = Date(2024, 3, 1) // months are 0-indexed, so 3 is april for (var f in fs) { // check date var insp_complete = Iif( DateDiff(threshold, f['Inspection_Date']) >= 0, 'Incomplete', 'Inspection Completed' ) // push into array Push( out_dict['features'], { attributes: { objectid: f['objectid'], inspection_complete: insp_complete }} ) } return FeatureSet(Text(out_dict))   Another method is to use GroupBy or Distinct. These functions let you use SQL to create new "fields" in the output, but excecute on the server side, and are much faster. Not as fun to work with timestamps, though. The particular format of the date functions will depend on the database your service is coming from. var sql = `CASE WHEN Inspection_Date < TIMESTAMP '2024-04-01 00:00:00' THEN 'Incomplete' ELSE 'Inspection Complete' END` return Distinct( fs, [ { name: 'objectid', expression: 'objectid' }, { name: 'inspection_complete', expression: sql } ] ) If your system doesn't like the timestamp syntax, you can get away with using EXTRACT most of the time, something like: CASE WHEN EXTRACT(MONTH FROM Inspection_Date) >= 4 AND EXTRACT(YEAR FROM Inspection_Date) = 2024 THEN 'Inspection Complete' ELSE 'Incomplete END ... View more

Grouping by date in a chart won't give you nice categories like that, so you'd need some other way to get the categories. A Data Expression could do it, but why not just have a couple of Indicators? You can use the widget's built-in filtering to set a specific "before April 1st" date to get your "to be inspected" count, and filter for "on or after April 1" to get your "completed" count. ... View more

The phrase "at least one" sounds like the function Any. Put your conditions in an array, then use Any to return a true/false value if anything comes back. Any([ DomainName($feature,"Field1") != "Value1", DomainName($feature,"Field1") != "Value2", DomainName($feature,"Field1") != "Value3" && DomainName($feature,"Field2") != "Value1" ]) ... View more

Oof. It's been a minute since I worked with layouts through ArcPy. Creating a complex map series, or anything with multiple pages in it, can be an absolute pain in the neck. Personally? I just use QGIS for those kinds of things. I still don't really know the arcpy.mp module well enough to give you good guidance here, other than just avoid it unless you absolutely have to use it. ... View more

If you want your icon centered in a table column, or you want multiple colors, etc., you can actually just pipe in raw SVG into the displayText.       ... View more

Can you place a filter in the chart's settings to exclude rows with 0s in those fields? ... View more

Pretty hard to do in a list, but the table widget implements row striping and a "row index" global. Would be nice if there were something like "list index" that could be used similarly. ... View more

I think Arcade is the route to take on this. I don't think we can make it dynamic, if that matters. Arcade has a function built in for standard deviation, but requires your values to be in an array, not a FeatureSet. To make things easier on your dashboard, we can calculate all 4 things in one go. var fs = FeatureSetByPortalItem( Portal('your portal URL'), 'itemid of layer', 0, // layer index ['fields', 'you', 'need'], false ) // value array var numbers = [] for (var f in fs) { Push(numbers, f['field_you_are_calculating_stdev_for']) } // get standard deviation var sdev = Stdev(numbers) // mean var mean = Average(numbers) // output dict for indicators var out_dict = { fields: [ {name: 'stat', type: 'esriFieldTypeString'}, {name: 'value', type: 'esriFieldTypeDouble'} ], geometryType: '', features: [ {attributes: {stat: 'pos_one_stdev', value: mean + sdev}}, {attributes: {stat: 'pos_two_stdev', value: mean + (sdev * 2)}}, {attributes: {stat: 'neg_one_stdev', value: mean - sdev}}, {attributes: {stat: 'neg_two_stdev', value: mean - (sdev * 2)}} ] } return FeatureSet(Text(out_dict)) Once you've got that, you'll end up with a four-row FeatureSet with your values. Just set those indicators to Feature and filter each so that the relevant statistic is shown. Apologies for the lack of formatting in the post. The site keeps insisting that there is invalid HTML in my post. ... View more

You'll want to use an Arcade popup element for this, where you can include HTML. Also, when you're series of if/else/then statements are nice and simple like this, you can replace them with a When statement. "When(condition1, response1, ... conditionN, responseN, fallback_response)" However, when your conditions all use the same field, you can also just replace it with Decode. "Decode(field, value1, response1... valueN, responseN, fallback_response)" var maintainer = Decode( $feature.MAINTENANCE, 'CITY', '<a href="link to city URL">The City of Annapolis</a>', 'STATE', '<a href="link to state URL">State Highway Administration</a>', 'PRIVATE', 'A Private Entity', // no link on this one! 'NAVAL ACADEMY', '<a href="link to academy URL">United States Naval Academy</a>', 'COUNTY', '<a href="link to county URL">Anne Arundel County</a>', 'FUTURE (CITY)', 'Private but future City', 'UNKNOWN' ) return { type: 'text', text: maintainer }   ... View more

Yeah, Esri's vector tiles aren't really made with this sort of thing in mind. You can absolutely get popups off of vector tiles, but only if you're willing to make your map from scratch. Here's an example in OpenLayers: https://openlayers.org/en/latest/examples/vector-tile-info.html   ... View more

Seems to work fine. Works as an expression and static HTML.   ... View more

Closest I've ever gotten was using Union in a loop, but it performs terribly with large numbers of features. ... View more

Survey123 has the option to cache answers for future forms. For each question, the web designer provides an option to cache the answer. In the web app, after submitting a survey record, the answer to the question will be cached in the browser and preloaded into the next submission made for this survey on that device. Caching an answer can be set for all question types except Audio, Image, File upload, and Signature. There should also be a way to select an item from the app's Sent folder and copy it to a new survey, where you'd only need to adjust the point. ... View more

Personally, I get an extract from GeoFabrik (https://download.geofabrik.de/) and use osm2pgsql to get it into a PostGIS database, which I can then connect to directly in Pro and use as needed. GeoFabrik updates their extracts every day, and you can easily schedule the osm2pgsql process to run on 24 hour intervals. There are more advanced ways of continually pulling in and applying changes from OSM to keep your data to within a few minutes of the main dataset. But for us, < 24 hours is good enough, so it hasn't been worth digging into. I don't do any routing at my work, so I don't have any guidance on Network Analyst, sorry. ... View more