topic Re: List possible combinations - Arcade in ArcGIS Online Questions

List possible combinations - Arcade

explocarto — Sun, 01 Sep 2024 23:17:06 GMT

Hello,

I have a table with this structure.

As output i need a FeatureSet wich lists by zone all the possible combinations between "season_begin" and "season_end". Count the number of phenomena between these combinations and the average.

Can someone help me ?

Re: List possible combinations - Arcade

explocarto — Tue, 03 Sep 2024 22:24:06 GMT

Hello @jcarlson,

Can you help me again ?

kind regards

Re: List possible combinations - Arcade

jcarlson — Wed, 04 Sep 2024 14:05:24 GMT

Are the "phenomena" the name field? Or is that some other field not pictured?

Re: List possible combinations - Arcade

explocarto — Wed, 04 Sep 2024 23:54:05 GMT

Yes the phenomena correspond to the name field.

kind regards

Re: List possible combinations - Arcade

jcarlson — Thu, 05 Sep 2024 16:45:48 GMT

Honestly unsure how to get an average from a string field, but this will give you the count of phenomena per unique zone/begin/end combination.

var fs = FeatureSetByPortalItem( Portal('your portal url'), 'itemid of your service', 0, // layer index ['fields', 'you', 'need'], false ) return GrouBy( fs, [ 'zone', 'season_begin', 'season_end' ], [ { name: 'the_count', expression: 'phenomena', statistic: 'count' }, ] )