Latest Contributions by KenBuja

I've always had difficulties in working with date functions in the Filter's sql statement. The workaround I came up with (working with some of my own data) is to use the OrderBy function to sort by the FeatureSet by the state and date and use the Distinct function to get the unique states. I then loop through the distinct states to filter the sorted list and use the first entry. This also uses @jcarlson's Memorize function, since lots of Filter calls will slow down your script. function Memorize(fs) { var temp_dict = { fields: Schema(fs)['fields'], geometryType: '', features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(Text(temp_dict)) } var fs = FeatureSetByPortalItem( Portal('https://noaa.maps.arcgis.com'), 'b9c527e0cb6d4c7fac39981f966fdd65', 0, ['STATE', "BEGIN_DATE", 'Station_ID'], false ); //var fs_gp = GroupBy(fs, ['STATE'], [{name: 'recentDate', expression: 'BEGIN_DATE', statistic: 'MAX' }]); var orderedFS = Memorize(OrderBy(fs, "STATE ASC, BEGIN_DATE DESC")) var distinctStates = Distinct(fs, ["STATE"]); var theDict = { fields: [{name: 'Name', type: 'esriFieldTypeString'}, {name: 'Station', type: 'esriFieldTypeString'}, {name: 'BEGIN_DATE', type: 'esriFieldTypeDate'}], geometryType: "", features: [], }; var i = 0; for (var s in distinctStates) { var state = s.STATE; if (!IsEmpty(state)) { var f = First(Filter(orderedFS, 'STATE = @state')) theDict.features[i++] = { attributes: { Name: state, Station: f.Station_ID, BEGIN_DATE: f.Begin_Date } } } } return FeatureSet(Text(theDict));     ... View more

It looks like you're trying to use multiple fields from the $reference variable, but that only has the one value set up on the Data tab in the Reference section. Take a look at using Arcade to create a Data Expression that you'll use as the data source for the indicator. That will give you access to more things. There's a github page on expression examples you can look at for ideas. ... View more

This will give you the expected output (checked with a compound interest calculator)   var Sqft_Total = 1000; var Price_Per_SQFT = 3.00 var Number_Of_Years = 10 var Escalator = 1.5 var total = Sqft_Total * Price_Per_SQFT var output = `Year 1: ${Text(Round(total, 2),'$#,###.00')}` for (var i = 2; i <= Number_Of_Years; i++) { total = total * (1 + Escalator/100) output += `${TextFormatting.NewLine} Year ${i}: ${Text(Round(total, 2),'$#,###.00')}` } return output   which returns this "Year 1: $3,000.00 Year 2: $3,045.00 Year 3: $3,090.67 Year 4: $3,137.04 Year 5: $3,184.09 Year 6: $3,231.85 Year 7: $3,280.33 Year 8: $3,329.53 Year 9: $3,379.48 Year 10: $3,430.17" ... View more

You can use the Filter function var array1 = [1,3,5,6] var array2 = [3,6] function exists(i){ return !Includes(array2, i) } return Filter(array1, exists)   ... View more