There is currently no bitwise AND operator in Sisense, but (like me) you might want to do something like check whether a particular bit is set in a column (eg Column1 AND 16 = 16 would tell you that the fifth least significant bit of the value in Column1 was set).
You can do this comparison in Sisense SQL by using:
WHERE Column1/power(2,[bit_to_check]) % 2 = 1
The [bit_to_check] value has to be the 0-based bit position, so to check the fifth bit as in the example above you would use WHERE Column1/power(2,) % 2 = 1
Credit for this idea from this post.
Please sign in to leave a comment.