Skip to main content
  • EN

Hello,

 

I would like to total the number of times each record appears in the dataset. Here is an example of what I would like to count:

FMEquestion1I've tried using the FieldCalculator but I just keep getting 0's for the sum function. See photo below:

FMEquestion2I'm not sure how to set the parameters in the FieldCalculator to perform this function. Here is what I have currently set:

FMEquestion3Thank you!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hi,

 

You could try using the Total Count in the Statistic Calculator grouping by your attribute.

You just need to add the LocationID attribute as the GroupBy here

Capture

You just need to add the LocationID attribute as the GroupBy here

Capture

@ebygomm​  and @alexist​  Thank you that gave me the count!

Reply


Community Stats

30,162
Posts
114,488
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.