Skip to main content
Question

I am trying to count the number of features based on 2 filters but my expressions are not returning what I need.

  • October 3, 2022
  • 1 reply
  • 9 views

Forum|alt.badge.img

My data has a 'label' attribute, example - TCY/D/N3000000. I split this to just get the 'TCY' and created a list, then an attribute (DA_abrv) based on that list value. Now I need to count how many features are within my dataset containing 'TCY' in the label and another attribute value, example: (status = 6 and DA_abrv = 'TCY'). Consented is 'status = 6', Engaged is 'status = 2'

 

My output needs to look like this:

 

DA Consented Engaged

TCY 5 1

BGS 10 12

LAY 30 8

 

I have tried setting a conditional value in the writer to return this but it's not working. Any help would be greatly appreciated.

 

1 reply

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • October 3, 2022

I would use the Counter transformer with the Group By parameter set to DA_abrv, and your second attribute. You will need to set the Count Scope to Local in order to enable the Group By option. After that I would use the StatisticsCalculator to get the max count of _count for your report.


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