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.
Based on the lack of responses, either I am to assume this is just not doable or is just above the level of people on the forum (obviously me included ). I guess it is just easier to write an excel macro and I will go with ol' trusty then. But it does continue to seem to me that tableau just doesn't live up to its hype.