Latest Contributions by KenBuja

No, this will be the data source of the indicator. In the Settings window, click the Change button for the Layer and create a new data expression. ... View more

Can you post your script? Does it return an empty FeatureSet or the number 0? ... View more

Unfortunately, you can't use label formatting tags in Arcade. ... View more

Have you used @JRhodes's suggestion to use console messages to check your variables at various steps? ... View more

In Line 10 of your first post and line 20 in your second post, you're using Top to get the first record, but Top returns a FeatureSet, not a Feature. You have to use First instead to use that feature in the next line. Try this (with a couple of other minor modifications) // Define a Featureset (status) from the layer "Cyanobacteria_Public View" in the $map // that contains the attribute ['cyano_risk_tier'] var status = FeatureSetByName($map, "Cyanobacteria_Public View"); // Define a variable (risk) to store the value we want // Get the value by Intersecting the pond polygon location // with the FeatureSet "Cyano Ponds Public View", or status // var risk = Top(OrderBy(Intersects(status, Buffer($feature, 30, "meters")), 'fluorometry_date DESC'), 1); // Not sure if this works // Instead, try to match by CCC GIS ID var CCC_GIS_ID = $feature.CCC_GIS_ID; //var IDS = "CCC_GIS_ID = '" + CCC_GIS_ID + "'"; var RelatedReads = Filter(status, "CCC_GIS_ID = @ccc_GIS_ID"); //var numrelreads = count(RelatedReads); if (Count(RelatedReads) == 0) return "No updated Information"; var LastSampleDate = First(OrderBy(RelatedReads, "fluorometry_date DESC")); var edit_datetime = Date(LastSampleDate); var now_datetime = Now(); var days_dif = DateDiff(now_datetime, edit_datetime, "days"); if (days_dif <= 30) return status['cyano_risk_tier']; return "No updated Information";   ... View more

You had a couple of mistakes (missing commas and an errant return) var contest = Decode(f["Contest_title"],"President of the United States (REP)","A", "United States Senator (REP)", "C", "Attorney General (REP)", "E", "Auditor General (REP)", "G", "State Treasurer (REP)", "I", "Representative in Congress -13th District (REP)", "K", "Representative in the General Assembly -78th District (REP)", "O", "Delegate to the Republican National Convention (REP)" , "M", "Alternate Delegate to the Republican National Convention (REP)", "P", "Republican Committee Person - Bedford Borough West (REP)", "Q", "Republican Committee Person - Bedford Township 1 (REP)", "R", "Republican Committee Person - Bedford Township 2 (REP)", "S", "Republican Committee Person - Everett Borough (REP)", "T", "Republican Committee Person - Hopewell Township (REP)", "U", "Republican Committee Person - King Township (REP)", "V", "Republican Committee Person - West Providence Township (REP)", "W", "Republican Committee Person - West St. Clair Township (REP)", "X", "Republican Committee Person - Woodbury Township (REP)", "Y", "President of the United States (DEM)", "B", "United States Senator (DEM)", "D", "Attorney General (DEM)", "F", "Auditor General (DEM)", "H", "State Treasurer (DEM)", "J", "Representative in Congress -13th District (DEM)", "L", "Delegate to the Democratic National Convention (DEM)", "N", "Unsatisfactory"); ... View more

Can you post your new code? ... View more

With a "return" in each of the if statements, the code will short-circuit and return a single letter (or "Unsatisfactory") for the first feature. You'll want to use the Decode function to return a variable for that logic to be used later. Here, I'm just making a guess in this code without seeing your data and what you're trying to accomplish. It's also untested, so it might need modification. var portal = Portal('https://.maps.arcgis.com') var fs = FeatureSetByPortalItem( portal, '155af3e091404240acd2904e34a07bf6', 0, ['Contest_title'], false ); // Create empty array for features and feat object var features = []; var feat; for (var f in fs) { var contest = Decode(f["Contest_title"],"President of the United States (REP)","A", "United States Senator (REP)", "C", "Attorney General (REP)", "E", //the rest of the options "Delegate to the Democratic National Convention (DEM)", "N", "Unsatisfactory"); feat = { attributes: { Contest_ID: contest, }, }; Push(features, feat); } var choicesDict = { 'fields': [ { 'name': 'Contest_ID', 'type': 'esriFieldTypeString'}], 'geometryType': '', 'features': features }; // Convert dictionary to featureSet. var fs_dict = FeatureSet(Text(choicesDict)); // Return featureset after grouping by hazard types. return GroupBy(fs_dict, ['Contest_ID'], [{ name: 'Contest_ID', expression: 'Contest_ID', statistic: 'MAX' }]); .  ... View more

Querying dates in SQL can be picky, especially if there is time involved. In some testing I was doing on my data, if I queried it using "Date = '07/10/2016'", it would return 0 features. If I queried using "Date > '07/10/2016' AND DATE1 <= '07/11/2016'", it would return 29 records. The query "cast(Date1 as date) = cast('7/10/2016' as date)" also returned 29 records. However, there are 36 records on that date, since I have several records after 8 pm ET (which is after midnight on the next day in UTC). This query finally returned all 36 records var offset = -TimeZoneOffset(Now()); //returns time zone offset in milliseconds. Use - for Western Hemisphere var startDate = DateAdd(Date(2016,06,10), offset, 'milliseconds'); var endDate = DateAdd(startDate, 1, 'day'); var filtered = Filter(fs, "Date1 > @startDate AND DATE1 <= @endDate"); return (Orderby(filtered, 'Date1 ASC'));     ... View more