Latest Contributions by XanderBakker

Hi @FPGIS_FrancescaRohr , Sorry for the delay, but I was in meetings all afternoon. I was looking at the expression and I can't see any problem with it. I assume as you do that it concerns the SQL. I think you are creating it correctly, but I can't validate without having access to the data. In case possible, can you share the data? You could create a group, share the data to that group and invite me using "xbakker.spx" to the group. Some minor changes to your expression, but none that will solve the issue. var inspections = FeatureSetByName($map, "UCF Tree Inspections - UCF Tree Inspections"); var treeuniqueid = $feature["Grant_ID"] + "_" + $feature["Tree_ID"]; var sql = "Tree_UniqueID = @treeuniqueid"; Console(sql); var inspection = Filter(inspections, sql); var cnt = Count(inspection); var history = ""; if (cnt > 0) { history = "inspection(s): " + cnt; } else { history = "No inspections"; } return history;   ... View more

Thanks @Anonymous User for jumping in. Will you get back when you know if the behaviour in Pro is indeed a bug? It would be nice to have a setting in ArcGIS Pro where the user can decide in what time zone he/she wants to see a date-time. Do you know if this is on the roadmap? ... View more

Hi @kshahmmp , I wish that was possible. Arcade would be able to extract whatever other features are beneath the feature the user clicked on, but this won't stop ArcGIS to consult the feature below and apply the same Arcade expression to see what other features it can find. This will come at a cost (performance) and you will still see the "1 of 2" and "2 of 2" (although in this case, the user would not have to go to the second feature to obtain the details. ... View more

Hi @FPGIS_FrancescaRohr , Quick question: does your data use a Relationshipclass? If so, you are probably better off using the "FeatureSetByRelationshipName" to get to the related records. ... View more

Hi @aroininen , If you look at my code you will see that the Sum is using "fs" (the filtered featureset) and not "sconnection" (the $layer). This is why it is not working for you. ... View more

Hi @ZachBodenner , There is no need to use Arcade in this case. Just go into the configure pop-up option of the layer, there you will find the option "configure attributes" and in the window that appears you can change the alias of the field name:    ... View more

Hi @aroininen , The first question would be to know if the feature you click on is part of the layer where you want to get the totals from (this would allow us to use $layer)? If not, is the layer in the map (you would probably use FeatureSetByName? If that is not the case, the way to access the layer will be a bit different using FeatureSetByPortalItem. The second question is,  do you want to return 3 separate values and handle them as separate virtual fields (which would need an Arcade expression for each total) or is returning a text with the 3 totals what you are looking for? Have a look at the example below: // access the layer of the feature the user clicked on var fs1 = $layer; // access another layer that is available in the map var fs2 = FeatureSetByName($map,"Parcels_And_Buildings - Tax Parcels") // calculate the sum of floor count of the first featureset var tot1 = Sum(fs1, "FLOORCOUNT"); // calculate the sum of the Residential Floor Area fom the seconf featureset var tot2 = Sum(fs2, "RESFLRAREA"); // calculate the sum of the Building Area fom the seconf featureset var tot3 = Sum(fs2, "BLDGAREA"); // create a string and append each total on a new line var result = "Floorcount: " + tot1; result += TextFormatting.NewLine + "Residential Floor Area: " + Round(tot2, 0); result += TextFormatting.NewLine + "Building Area: " + Text(tot3, "000.000.000 m²"); // return the formatted text return result;   This will return a single text containing the 3 sums: Floorcount: 26405 Residential Floor Area: 133370425 Building Area: 397.900.000 m² ... View more

Hi @FPGIS_FrancescaRohr , The problem, in this case, is that you are returning a featureset to the pop-up. That is something the pop-up can't visualize. It does show in the expression builder, but this does not mean that it will show in the pop-up. You will probably have to loop through the features in the featureset and construct the text that you want to return.  Have a look at https://community.esri.com/t5/arcgis-online-documents/using-featuresetby-functions-in-arcade-to-drill-down-to-other/ta-p/918691 and the second code block where a list of maintenances of a hydrant is formatted and returned to the pop-up.  ... View more

Hi @DavidColey , The error "Warning, return type must be a number" occurs when you already have a category field selected and you are defining an expression. This expression will be used as the second field and must be numeric. I have had the same error and when I removed the field of the symbology with the cross "x" just above the "+ expression" it worked as expected.  Sorry for the screenshot in Spanish... ... View more

Hi @erica_poisson , I assume that the date is passing as a string. I provided another above some code to pass the date as epoch which might work. ... View more

Hi @erica_poisson , I have a better idea. Can you try this: // settings var p = 'https://www.arcgis.com'; var itemID_CMpts = 'xxx'; var layerID_CMpts = 0; var relationshipName = ""; // access first featureset var fs1 = Filter(FeatureSetByPortalItem(Portal(p), itemID_CMpts, layerID_CMpts, ['Point_Status', 'EQ_File_Number', 'Inspection_Date'], true), "Point_Status ='Unstable' AND EQ_File_Number In ('EQ2015-078', 'Eq2013-026', 'EQ2018-082', 'EQ2018-052', 'EQ2001-080X', 'EQ2003-021', 'EQ1989-015', 'EQ2002-023', 'EQ2002-045X', 'EQ2019-110', 'EQ2020-017', 'EQ2019-091', 'EQ2018-029', 'EQ2020-033', 'EQ2019-036', 'EQ2020-052', 'EQ2019-064', 'EQ2017-040', 'EQ2020-031', 'EQ2021-003', 'EQ2011-016', 'EQ2017-026', 'EQ2021-020')"); // create data schema var Dict = { 'fields': [ {'name': 'EQNum', 'type': 'esriFieldTypeString'}, {'name': 'InspecDate', 'type': 'esriFieldTypeDate'}, {'name': 'PtStatus', 'type': 'esriFieldTypeString'}], 'geometryType': 'esriGeometryPoint', "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, 'features':[]}; // analysis and fill Dict var i = 0; for (var f in fs1) { var fs2 = FeatureSetByRelationshipName(f, relationshipName, ['Point_Status_revisit'], false); var cnt = Count(fs2); if (cnt == 0) { Dict.features[i] = { 'geometry': { 'x': Geometry(f)["X"], 'y': Geometry(f)["Y"] }, 'attributes': { 'EQNum': f["EQ_File_Number"], 'InspecDate': DateDiff(f["Inspection_Date"], Date(1970, 0, 1, 0, 0, 0), "milliseconds"), 'PtStatus': f["Point_Status"] } }; i++; } } Console(Text(Dict)); return FeatureSet(Text(Dict));   ... View more

Hi @erica_poisson , I assume that despite the changes it is still not working right? I validated the json that is returned in json lint and it is valid. I have also stored the json in a file and used json 2 feature and it creates a valid featureclass with the features. The only thing that does not come through are the dates. Maybe it is expecting a value (epoch) rather than what it has at this moment. Could you do another test and change the output field type of the date to string. Just to see if that passes. If so we will focus on converting the date to epoch. ... View more