2 Replies Latest reply on Dec 2, 2016 8:49 AM by D Barnetson

# Counting the number of occurrences based on a condition

Hi,

I have location data with the signal as 1 or 0 (Below is the example).

Is it possible to add a dot in the map for signals where 0 is repeated more than 3 times using custom calculation?

longitude             latitude     Signal

3.075110768 50.63757207 1

3.075110768 50.63757207 1

3.075110768 50.63757207 1

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 1

3.075110768 50.63757207 1

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207   1

3.075110768 50.63757207 1

3.075110768 50.63757207 0

3.075110768 50.63757207 0

3.075110768 50.63757207 1

 longitude latitude Signal 3.075111 50.63757 1 3.075111 50.63757 1 3.075111 50.63757 1 3.075111 50.63757 0 3.075111 50.63757 0 3.075111 50.63757 0 3.075111 50.63757 0 3.075111 50.63757 1 3.075111 50.63757 1 3.075111 50.63757 0 3.075111 50.63757 0 3.075111 50.63757 0 3.075111 50.63757 0

Thanks,

Kali

• ###### 1. Re: Counting the number of occurrences based on a condition

Try This:

create a calculation:

{Fixed longitude, latitude:Sum(Signal)} > 3

Drag in filter shelf and set true

• ###### 2. Re: Counting the number of occurrences based on a condition

Hi Kali,

You can try something like this calculation:

if attr([Signal])='0' then if count([Signal])>=3 then 1 else 0 END

end

Hope this helps

Don