Data expression coding help

JB_SEPA

Can anyone please save me from going insane with this nagging issue?

I'm trying to create a featureset of farms that are purely "Good practice" (Status =3 or Good=1). Here's my featureset of farm issues where farmcode (farm identifier) is not unique.

I'm trying to select farms that ONLY have Status=3 or Good =1 for each FarmCode grouping. Sometimes a  FarmCode will be unique, sometimes multiples depending how many issues there are on a farm.

Cheers for any pointers,

Jonathan

 

JB_SEPA

Is solved this pretty quickly after posting. I applied a GroupBy as follows:

Var Tester2 = GroupBy(Tester, ['FarmCode'], 
[{name: 'Good', expression: 'Good', statistic: 'SUM'},
{name: 'Bad', expression: 'Bad', statistic: 'SUM'},
]);

 Seems to work great.....just checking results now.