AGOL Dashboard - Grouping values based on 2 data fields

Question

Hi,

I'm working on a dashboard that will present our lab results for our samples. Basically, we have multiple samples taken at a location and then we received the results for each sample.

I need a TABLE that could summarize how many results came back as positive/negative for each location.

I know it's possible to group by 1 category but is there a way to group by 2 categories?

Thanks!

Ken

KenBouchard · Answer

Oh...  arcade!  I'm just not sure how/where to use it.  Thanks, it points me to the right direction, I'll investigate this!  🙂

I've did little arcade coding before but not much.  However, I can appreciate this is a very powerful skill to possess.

Do you guys have any recommendations on resources to learn and develop my arcade skills?

(I already did the "Stay in the Game with ArcGIS Arcade" paid course from ESRI)

Thanks!

jcarlson · Answer

Piggybacking on this: Data Expression is the way to go, and with a nicely written GroupBy function, it wouldn't be that hard.

var fs = FeatureSetByPortalItem(
  Portal('arcgis.com'),
  'itemid of layer',
  0,
  ['location', 'results'],
  false
)

return GroupBy(
  fs,
  ['location', 'results'],
  {name: 'count', expression: '1', statistic: 'COUNT'}
)

MobiusSnake · Answer

I think using a Data Expression as your source (rather than a table directly) would let you do this.  You'd want to create a derived attribute that combines the two fields you're interested in.