Group By Expression

Cheetah24

Hi

 

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

kenbuja

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.