topic Re: Arcade - how calculate Field in FeatureSet in ArcGIS Dashboards Questions

Arcade - how calculate Field in FeatureSet

VHolubec — Fri, 26 Nov 2021 19:20:12 GMT

Hello,

I am trying to get work an Arcade expression to create a FeatureSet, which I want to use then for Serial chart.
In simplification, I am taking an attribute ZONE from the layer:

var fs = FeatureSetByPortalItem(Portal('https://arcgis.com'),'e7ad315d17a742fda44fb63cd311152a',0,['ZONE'], false)

The ZONE attribute is a string which looks like P6-0176. The goal is to create a field in the FeatureSet which recalculate the ZONE filed but keeps the first two chars only - so the result for this example would be P6.

So I am creating a new FeatureSet definition, and the attribute ZONE I would like to use in LEFT function.
But if I use the code like this:

var novy = {
'fields': [{'name':'Zona', 'type':'esriFieldTypeString'}],
'geometryType': '',
'features':
[{'attributes':
{'Zona': Left((fs,'ZONE'), 2)
}}]};
return FeatureSet(Text(novy))

The result is the error for the LEFT function.

What is the correct syntax to call the column ZONE from the original FeatureSet FS in the LEFT function? Or is there any other way (and this is not the correct one) how to recalculate the ZONE attribute in original FeatureSet FS.

Thank you for any ideas

Re: Arcade - how calculate Field in FeatureSet

JohannesLindner — Tue, 30 Nov 2021 08:31:06 GMT

To insert code:

You are trying to input a tuple of (FeatureSet, Text) into the Left function, which is not a valid argument.

According to the docs, the first argument can be Text, Array, Number, or Boolean.

You have to fill your feature set sequencially:

var fs = FeatureSetByPortalItem(Portal('https://arcgis.com'),'e7ad315d17a742fda44fb63cd311152a', 0, ['ZONE'], false) var novy = { 'fields': [{'name':'Zona', 'type':'esriFieldTypeString'}], 'geometryType': '', 'features': [] } for(var f in fs) { var new_f = {'attributes': {'Zona': Left(f.ZONE, 2)}} Push(novy.features, new_f) } return FeatureSet(Text(novy))

Re: Arcade - how calculate Field in FeatureSet

VHolubec — Wed, 01 Dec 2021 10:37:55 GMT

Thank you very much @JohannesLindner, it works great!

Re: Arcade - how calculate Field in FeatureSet

PeterMilenkovic — Wed, 15 Jun 2022 06:32:15 GMT

Hello,

Thought this would be a suitable thread, I have a very similar requirement. Generating a featureset to use as the data source for a dashboard graph.

var fs = FeatureSetByPortalItem(Portal('https://cityofsydney.maps.arcgis.com'), '103a3484d254440caede4c2a28c46c5b', 9,['StreetSectionArea','StreetFinalForCityReview','STMP2022F1Sp'],false); var fsfilter = Filter(fs, 'StreetFinalForCityReview = 5') var F1Sp_GB = Top(OrderBy(GroupBy(fsfilter, ['STMP2022F1Sp'], [ { name: 'SumF1SP', expression: 'StreetSectionArea', statistic: 'SUM' } ]),'SumF1SP DESC'),10) var TotAreaFinalised = SUM(F1Sp_GB,'SumF1SP') var joinedDict = { fields:[ {'name':'STMP2022F1Sp','type': 'esriFieldTypesString'}, {'name':'SumF1Sp','type': 'esriFieldTypeBigInteger'}, {'name':'F1Sp_Per','type': 'esriFieldTypeBigInteger'}], 'geometryType': '', 'features':[] } for (var f in F1Sp_GB){ var new_f = {'attributes': {'SPECIES': DomainName(f,"STMP2022F1Sp"), 'SPArea': f["SumF1SP"], 'SPPer': (f["SumF1SP"]/TotAreaFinalised)*100}} Push(joinedDict.features, new_f) } return FeatureSet(Text(joinedDict))

When i return the raw dictionary i can see the correct values, but the featureset does not show when i have the dictionary wrapped inside FeatureSet(Text()).

Can't figure out what i have done wrong.

Thanks

Peter

Re: Arcade - how calculate Field in FeatureSet

JohannesLindner — Wed, 15 Jun 2022 09:13:09 GMT

Your field declaration and the fields of your features have to match.

name
- STMP2022F1Sp, SumF1Sp, F1Sp_Per
- SPECIES, SPArea, SPPer
type
- according to the docs, there is no BigInteger, only Integer
- SPArea and SPPer are probably Double, so either use esriFieldTypeDouble or use Round(x, 0)

Re: Arcade - how calculate Field in FeatureSet

JohannesLindner — Wed, 15 Jun 2022 09:15:04 GMT

Also, it should be "esriFieldTypeString", not "esriFieldTypesString".

Re: Arcade - how calculate Field in FeatureSet

PeterMilenkovic — Wed, 15 Jun 2022 10:34:49 GMT

Thanks so much for your help, it's working now!

Have another question now, the domain name does not get returned, only the code..

I assume the f in my loop is the feature in the featureset.

DomainName($feature, 'fieldName')

Re: Arcade - how calculate Field in FeatureSet

PeterMilenkovic — Wed, 15 Jun 2022 23:09:31 GMT

Figured it out now and i think i understand what was happening...

When i created the variable F1Sp_GB (group by table), it removed the domain... i was just left with the code, to bring back the domain name i had to use the original featureset and insert the code from group by table.

var fs = FeatureSetByPortalItem(Portal('https://cityofsydney.maps.arcgis.com'), '103a3484d254440caede4c2a28c46c5b', 9,['StreetSectionArea','StreetFinalForCityReview','STMP2022F1Sp'],false); var fsfilter = Filter(fs, 'StreetFinalForCityReview = 5') var F1Sp_GB = Top(OrderBy(GroupBy(fsfilter, ['STMP2022F1Sp'], [ { name: 'SumF1SP', expression: 'StreetSectionArea', statistic: 'SUM' } ]),'SumF1SP DESC'),10) var TotAreaFinalised = SUM(F1Sp_GB,'SumF1SP') var joinedDict = { fields:[ {'name':'STMP2022F1Sp','type':'esriFieldTypeString'}, {'name':'SumF1Sp','type': 'esriFieldTypeDouble'}, {'name':'F1Sp_Per','type': 'esriFieldTypeDouble'}], 'geometryType': '', 'features':[] } for (var f in F1Sp_GB){ var new_f = {'attributes': {'STMP2022F1Sp': DomainName(fs,'STMP2022F1Sp',f['STMP2022F1Sp']), 'SumF1Sp': round(f['SumF1SP'],0), 'F1Sp_Per': round((f['SumF1SP']/TotAreaFinalised)*100,2)}} Push(joinedDict.features, new_f) } return FeatureSet(Text(joinedDict))