Question

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

  • 3 October 2022
  • 1 reply
  • 1 view

Badge

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

Userlevel 3
Badge +26

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.

Reply