-
1. Re: COUNT and CONTAINS?
Joe OppeltDec 21, 2018 10:31 AM (in response to sue slivan)
Your calc will return only the first "hit" in that long string of ELSEIFs.
If a hypothetical [Question Type] is "Archives ILL", your calc will only count the "Archives" part and will stop looking further. Typical computation logic for compound statements stops as soon as the first TRUE condition is hit. And that's what Tableau does.
-
2. Re: COUNT and CONTAINS?
Chris McClellanDec 21, 2018 1:56 PM (in response to sue slivan)
Adding to Joe's comment as well, in computer logic "Archives" is not the same as "archives", so you would have to add a LOWER() around your CONTAINS() so that you're actually doing "archives" = "archives" but you might want to leave "ILL" as "ILL" depending on your data.
-
3. Re: COUNT and CONTAINS?
Joe OppeltDec 21, 2018 2:02 PM (in response to Chris McClellan)
Chris!! Haven't seen you around lately! (Maybe we just haven't frequented the same threads...)
Merry Christmas to you, man! Some day I would like to experience a summertime Christmas! (But at least I do a little Aussie Christmas when I listen to my Christmas in Australia CD. "Six White Boomer", and other Aussie favorites. )