Skip to main content
Solved

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

  • October 21, 2020
  • 3 replies
  • 222 views

cshir065
Forum|alt.badge.img

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!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best answer by alexist

Hi,

 

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

  • Best Answer
  • October 21, 2020

Hi,

 

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


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • October 21, 2020

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

Capture


cshir065
Forum|alt.badge.img
  • Author
  • October 21, 2020

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

Capture

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