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
  • 153 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.

View original
Did this help you find an answer to your question?

3 replies

A
  • alexist
  • 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+32
  • ebygommInfluencer
  • Influencer
  • October 21, 2020

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

Capture

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

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

Capture

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

Reply


Helpful Members This Week

Community Stats

31,157
Posts
118,113
Replies
38,777
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.