Thanks Allison! I currently have a use case where I'm looking at the transition of the mode of a piece of equipment, but I'm struggling to make the above code work for me.
I want to look at the transition of mode 3 to 2 but I want my capsule to start at the time it entered state 3 and end when it leaves state 2. (not a set amount as shown in the example). I have some instances where this is 5 minutes and some where it is 2 seconds so using the transition text above some of my capsules have multiple transitions in them. (I shortened it to 4 seconds vs 1 minute to fix this, but then I can't get the information (performance of another tag) before/after that transition.
Additionally, my equipment can enter and exit state 3 without passing through state 2 and enter/exit state 2 without passing through state 3, so I can't use the advanced value filter. I hope this is enough information to help answer my question. Thank you
update: used simple composite condition of touches, Thank you