Sigma Community

Sigma bitwise expressions

Sigma Formulas and Functions

darien January 13, 2021, 6:09pm #1

How do I write/use in Sigma BITWISE operators?

yuri January 13, 2021, 6:14pm #2

If you are on SnowFlake, Snowflake has bitwise functions:
https://docs.snowflake.com/en/sql-reference/expressions-byte-bit.html

In order to call them from Sigma, you can use our passthrough function CallNumber() :

If you need to use any aggregate functions then you’ll need to call AggNumber (or whatever the return type is) instead of the CallNumber():

1 Like

system automatically bumped February 3, 2021, 7:25am #3

system automatically bumped February 24, 2021, 5:18pm #4

system automatically bumped March 18, 2021, 3:15am #5

system automatically bumped April 8, 2021, 4:56pm #6

system automatically bumped April 30, 2021, 12:15pm #7

system automatically bumped May 22, 2021, 8:03am #8

system automatically bumped June 13, 2021, 11:57pm #9

system automatically bumped July 6, 2021, 8:17pm #10

system automatically bumped July 29, 2021, 1:02pm #11

system automatically bumped August 21, 2021, 9:27am #12

system automatically bumped September 13, 2021, 9:31pm #13

system automatically bumped October 7, 2021, 12:50pm #14

system automatically bumped October 31, 2021, 3:15pm #15

system automatically bumped November 24, 2021, 6:30pm #16

system automatically bumped December 18, 2021, 9:02pm #17

system automatically bumped January 11, 2022, 10:12pm #18

system automatically bumped February 4, 2022, 11:59pm #19

system automatically bumped March 1, 2022, 8:00am #20