I would like a total count for how many times each record appears in the dataset. | Community

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:

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

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

FMEquestion3 Thank you!

Page 1 / 1

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