1 Reply Latest reply on Oct 25, 2016 6:40 AM by David Meyer

    Counting number of times a particular ordering happens in string

    David Meyer

      Greetings,

       

      I have been struggling with this a couple of days now and have spent a better portion of today looking on forums already for help on this. 

       

      Say I am looking the following 5 repair activity logs

       

      Repaired TX Q1 & RX Q3

       

      Repaired TX Q2 & RX Q1

       

      Repaired TX Q1

       

      Repaired RX Q4

       

      Repaired RX C4, Q1

       

      Where Q is just the reference designator for a transistor, and C is a capacitor. 

       

       

      Now I want to count the number of times that RX appears followed by any Transistor (answer should be 4 in this case)

       

      Also how do I count the number of times RX appears followed by Transistor 1 (ie Q1) specifically (answer should be 2 in this case)

       

      Lastly how do I count the number of times TX appears and is followed by transistor 1 specifically but will not count any transistor 1 that follows RX (see second repair log for what Im referring to, answer should be 2 in this case)

       

      Im pretty new to tableau so forgive me if this is easy.

      Thanks!

      David Meyer