Hi,
In my data there are multiple "Closed" strings. For example "5-Closed" and "6-Closed". The formula works that I have attached when I used just one "6-Closed". How can I add in more than one string so I can have "5-Closed", "6-Closed", "7-Closed" for example?
Thanks
1 answer
I would use CONTAINS, as in ....
CONTAINS([Status with sequence], 'Closed')
will return TRUE if it find Closed at all.
-----------------------------------------------------------
2022 Tableau Forums Ambassador
Based in Sydney, Australia (GMT+11)
Please upvote my helpful replies and choose Select as Best Answer if it really is the best :)
