Latest Contributions by KenBuja

This should work. It calculates the number of days between the start date and end date and subtracts 15 hours for each day.   var StartDate = $feature.TimeStart var EndDate = $feature.TimeEnd var TimeDiff = DateDiff(EndDate, StartDate, 'hours') var DayDiff = DateDiff(DateOnly(EndDate), DateOnly((StartDate)), 'days') var HoursOff = 15 * DayDiff return TimeDiff - HoursOff       ... View more

Your loops (and you only need one instead of two) aren't getting the attribute from the feature correctly. It should be like this var Owners = FEATURESETBYNAME($DATASTORE,"Owners",["TractID","Contacted"]) var ID = $feature.TractID var OwnerID = Filter(Owners,"TractID=@ID") var Cont = 0 var NCont =0 for(var f in OwnerID) { if(f.Contracted == 'Yes') { Cont +=1 } else if(f.Contracted == 'No') { NCont +=1 } } if (Cont == 0 && NCont == 0) return null return Cont/(Cont+NCont) I also added a check to make sure you're not dividing by zero. ... View more

You can use the Schema function to get the domain information for all the fields. This code gives you an array of an array of the fields and their codedValue domain names. var dict = Schema($feature); var fieldsArray = dict.fields; var domainsArray = []; for (var i in fieldsArray) { if (HasValue(fieldsArray[i], 'domain')) { if (HasValue(fieldsArray[i].domain, 'codedValues')) { var domainArray = [fieldsArray[i].name] for (var d in fieldsArray[i].domain['codedValues']) { Push(domainArray, fieldsArray[i].domain['codedValues'][d].name) } Push(domainsArray,domainArray) } } } return domainsArray       ... View more

The code does work substituting my own portal item. Where is it breaking for you? Are you checking the output at various places in the code with Console to see if it's returning what you're expecting? var p = Portal("https://noaa.maps.arcgis.com/"); var fs = FeatureSetByPortalItem( p, '1624f1a86dca4af086cc13141a1b0e2b', 1, ['Authors'], false ); // Create empty array for features and feat object var features = []; var feat; // Split comma separated hazard types and store in dictionary. for (var feature in fs) { var split_array = Split(feature["Authors"], ',') var count_arr = Count(split_array) console(count_arr) for(var i = 0; i < count_arr; i++ ){ feat = { 'attributes': { 'split_choices': Trim(split_array[i]) } } Push(features, feat); }} // Empty dictionary to capture each hazard reported as separate rows. var choicesDict = { 'fields': [ { 'name': 'split_choices', 'type': 'esriFieldTypeString'}], 'geometryType': '', 'features': features }; // Convert dictionary to featureSet. var fs_dict = FeatureSet(choicesDict); //return fs_dict // Return featureset after grouping by hazard types. return GroupBy(fs_dict, ['split_choices'], [{ name: 'split_count', expression: 'split_choices', statistic: 'COUNT' }]);   ... View more

You can use the Left function if (Left($feature.ConduitSize, 6) == '1x1.25') return $feature.ClengthFt     ... View more

It throws a TypeScript error, but it does work. ... View more