1 Reply Latest reply on Jan 25, 2017 1:31 PM by Shinichiro Murakami

    Sequence Calculation?

    michael donnelly

      Hi there, im wondering if someone can help me, i wanted to create a calculation that counts a sequence, for example below is a table, id like to understanding winning runs, so id like to create a calculation that say Mike has 3 win sequences, John has a 1 win sequence, is this possible?

       

         

      NameDateResults
      Mike01/01/2017Win
      Mike02/01/2017Draw
      Mike03/01/2017Win
      Mike04/01/2017Win
      Mike05/01/2017Win
      John01/01/2017Lose
      John02/01/2017Draw
      John03/01/2017Win
      John04/01/2017Lose
      John05/01/2017Win