nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List possible combinations - Arcade

explocarto

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 ?

Find more posts tagged with

Arcade

Accepted answers

jcarlson

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' },
  ]
)

All comments

jcarlson

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' },
  ]
)

explocarto

Yes the phenomena correspond to the name field.

kind regards

jcarlson

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

explocarto

Hello @jcarlson,

Can you help me again ?

kind regards

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.