topic Re: Group By Expression in ArcGIS Dashboards Questions

Group By Expression

Cheetah24 — Mon, 14 Aug 2023 16:46:29 GMT

I'm trying to use a table and by species display totals for Alive, Injured and Dead animals. I am trying to use an expression and return a featureset that displays the totals for each of the mentioned but can't get it right. The field i have as the Data populated as 'AOR', "DOR' and 'IOR'. How can i sum these by value and display them in the correct column? So for each species I need to know how many were alive, dead and injured for the entire dataset.

Thanks

Re: Group By Expression

KenBuja — Mon, 14 Aug 2023 18:47:07 GMT

I use the GroupBy expression like this to get the counts of each attribute in a field (Habitat).

var totalHabitat = GroupBy(fs, 'HABITAT', { name: 'HabTypes', expression: '1', statistic: 'COUNT' });

This gives me this table by setting the Category field to "Habitat" and getting the sum of the "HabTypes" field.

Re: Group By Expression

Cheetah24 — Mon, 14 Aug 2023 19:54:21 GMT

Thanks for the response.

I had tried something similar but it just counts the number of rows. It doesn't seem to care what value is in my "Alive" field.

Re: Group By Expression

KenBuja — Mon, 14 Aug 2023 20:22:15 GMT

How is your data formatted? Do you have individual fields for each category showing how many animals are in that category? Your initial description sounded like there was one field showing if it's alive, injured, or dead.

Re: Group By Expression

Cheetah24 — Mon, 14 Aug 2023 23:23:54 GMT

So it would be something like this:

Bullfrog AOR
Mink DOR
Bullfrog DOR
Crow DOR

And what I would like to see in a table is
Species Alive Dead Injured
Bullfrog 1 1 0
Mink 0 1 0
Crow 0 1 0

Re: Group By Expression

Cheetah24 — Tue, 15 Aug 2023 15:26:19 GMT

Finally got it working. thanks for your help

Re: Group By Expression

KenBuja — Tue, 15 Aug 2023 15:36:11 GMT

Great! What was your solution?