Thanks Alexander this is helpful

I have attached a workbook with some simplified data. The field Panel.Growth is the parameter that i am looking at. I would like to calculate the number of times that this field changes from T to F for each antibiotic with a simple calculated field so that i can use the calculated value in some other calculations later. Any ideas would be appreciated.

Thanks

Thanks again Alexander this was very helpful

Pete

Alex

Firstly, I appreciate the work that you have put in to this and your method definitely yields the correct number for total transitions between the two states. This is further than I was able to get and your code is more elegant than my solution. The problem that I am facing is that I need to use the calculated number as a variable in further calculations and this does not seem possible with the results of table calculations. The count of T/F transitions was an idea as to how we might achieve a more complicated filter, I may have to come up with another method.

You are correct…sometimes as a newbie to scripting in Tableau part of the issue is learning what question to ask

Thanks for your help