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

    Counting the number of occurrences based on a condition

    Kali C

      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

       

                                                                                       

      longitudelatitudeSignal
      3.07511150.637571
      3.07511150.637571
      3.07511150.637571
      3.07511150.637570
      3.07511150.637570
      3.07511150.637570
      3.07511150.637570
      3.07511150.637571
      3.07511150.637571
      3.07511150.637570
      3.07511150.637570
      3.07511150.637570
      3.07511150.637570

      Thanks,

      Kali