Latest Contributions by XanderBakker

Hi @erica_poisson  and @KenBuja , You actually can return an in-memory featureset with the data that you want to graph. Since I am not sure what you are exactly after I will provide an example and you can adjust accordingly. See the example below (please note that the filter expression is using the syntax suggested by Ken). The first part is pretty much the same, but after getting the counts, you create a schema for the output featureset, and fill it with the data. In this case, it will be a featureset with 3 fields and only 1 row. This can be used in the Dashboard as data source.    var p = 'https://www.arcgis.com'; var itemID_CMpts = 'xxx'; var layerID_CMpts = 0; var itemID_join = 'xxx'; var layerID_join = 0; var fs1 = FeatureSetByPortalItem(Portal(p), itemID_CMpts, layerID_CMpts, ['Point_Status', 'EQ_File_Number'], false); var filterCMpts = Filter(fs1, "Point_Status ='Unstable' AND EQ_File_Number In ('EQ2015-078', 'Eq2013-026', 'EQ2018-082', etc)" ); var fs2 = FeatureSetByPortalItem(Portal(p), itemID_join, layerID_join, ['Point_Status_revisit', 'EQ_File_Number'], false); var filterJoin = Filter(fs2, "Point_Status ='Unstable' AND EQ_File_Number In ('EQ2015-078', 'Eq2013-026', 'EQ2018-082', etc)"); var CntCMpts = Count(filterCMpts); var CntJoin = Count(filterJoin); // create data schema var Dict = { 'fields': [ {'name': 'CntCMpts', 'type': 'esriFieldTypeInteger'}, {'name': 'CntJoin', 'type': 'esriFieldTypeInteger'}, {'name': 'CntCMptsMinusCntJoin', 'type': 'esriFieldTypeInteger'}], 'geometryType': '', 'features': []}; // fill the data schema with the data Dict.features[0] = { 'attributes': { 'CntCMpts': CntCMpts, 'CntJoin': CntJoin, 'CntCMptsMinusCntJoin': CntCMpts - CntJoin }} // return the featureset return FeatureSet(Text(Dict));     ... View more

Hi @kshahmmp , A couple of pointers here. When you want to access to value in a field called "FieldName1", you can use two ways to do this: $feature.FieldName1 $feature["FieldName1"]   The second option is preferred when you have a field name containing an underscore: $feature["Field_Name1"]   The code you posted raised a couple of questions: Do you want to return a text containing the values of 3 fields separated by a comma? Do you want to return the same 3 fields when FieldName4 is either 1 and 2 (or are there other fields to return?) Based on a number of assumptions see the example below. In this case, when FieldName4 is 1 a text with FieldNames 1, 2, and 3 will be returned and when FieldName4 is 2, a text with FieldNames 5, 6, and 7 will be returned. It uses the Concatenate function and provides an array (list) of the field values and the text to separate the field values. if ($feature.FieldName4 == 1) { return Concatenate([$feature.FieldName1, $feature.FieldName2, $feature.FieldName3], ", "); } else if ($feature.FieldName4 == 2) { return Concatenate([$feature.FieldName5, $feature.FieldName6, $feature.FieldName7], ", "); }     ... View more

Hi @Anonymous User  and @DanPatterson , Unfortunately, Arcade does not yet provide the possibility to project a geometry to a different coordinate system. There are some examples that allow calculating the corresponding latitude and longitude coordinates when you have the standard Web Mercator Auxiliary Sphere as input coordinate system.  The case mentioned above uses a mathematical formula to calculate the corresponding WGS 1984 coordinates. In case you have the formula you can implement it in Arcade. However, this might be complex and sometimes not very precise.  ... View more

Hi @GISUSER6 ,   I did a test with a local coordinate system and it will work with some minor adjustments:   You will need to: Use Buffer instead of BufferGeodetic Use Distance instead of DistanceGeodetic Place "var" before street in the for loop. var streetLayer = FeatureSetByName($datastore, "streets_WGS_Project", ["NAME"]); var searchDistance = 100; var streetIntersect = Intersects(streetLayer, Buffer($feature, searchDistance, "feet")); var cnt = Count(streetIntersect); var minDistance = Infinity; var name = Null if (cnt > 0) { for (var street in streetIntersect) { var dist = Distance(street, $feature, "feet"); if (dist < minDistance) { name = street.NAME; minDistance = dist } } } else { // pass no features found within search distance, name remains null } return name;   ... View more