# Functions

- [Aggregate Functions](/cascade/functions-and-expressions/functions/aggregate.md)
- [AVERAGE](/cascade/functions-and-expressions/functions/aggregate/average.md): Averages a list of numbers
- [CORR](/cascade/functions-and-expressions/functions/aggregate/corr.md): Calculates a correlation coefficient
- [COUNT](/cascade/functions-and-expressions/functions/aggregate/count.md): Returns the count of all non-null values in a column
- [COUNTD](/cascade/functions-and-expressions/functions/aggregate/countd.md): Returns count of distinct values within a column
- [COUNTBY](/cascade/functions-and-expressions/functions/aggregate/countby.md): Counts the number of values within a column, partitioned by the unique values of a separate column
- [COUNTIF](/cascade/functions-and-expressions/functions/aggregate/countif.md): Counts values based on a condition
- [COUNTIFS](/cascade/functions-and-expressions/functions/aggregate/countifs.md): Counts values based on multiple conditions
- [COVAR](/cascade/functions-and-expressions/functions/aggregate/covar.md): Calculates covariance
- [COVARP](/cascade/functions-and-expressions/functions/aggregate/covarp.md): Calculates population covariance
- [COVARS](/cascade/functions-and-expressions/functions/aggregate/covars.md): Calculates sample covariance
- [MAX](/cascade/functions-and-expressions/functions/aggregate/max.md): Finds maximum value in a list of numbers
- [MEDIAN](/cascade/functions-and-expressions/functions/aggregate/median.md): Finds median value of a list of numbers
- [MIN](/cascade/functions-and-expressions/functions/aggregate/min.md): Finds minimum value in a list of numbers
- [MAXBY](/cascade/functions-and-expressions/functions/aggregate/maxby.md): Finds the maximum of a list of numbers, partitioned by the unique values of a separate column
- [MINBY](/cascade/functions-and-expressions/functions/aggregate/minby.md): Finds the minimum of a list of numbers, partitioned by the unique values of a separate column
- [PERCENTILE](/cascade/functions-and-expressions/functions/aggregate/percentile.md): Computes nth percentile of a list of numbers
- [STDEV](/cascade/functions-and-expressions/functions/aggregate/stdev.md): Returns the standard deviation of a list of numbers
- [STDEVP](/cascade/functions-and-expressions/functions/aggregate/stdevp.md): Returns the standard deviation of a list of numbers
- [STDEVS](/cascade/functions-and-expressions/functions/aggregate/stdevs.md): Returns the sample standard deviation of a list of numbers
- [SUM](/cascade/functions-and-expressions/functions/aggregate/sum.md): Sums a list of numbers
- [SUMBY](/cascade/functions-and-expressions/functions/aggregate/sumby.md): Sums a list of numbers, partitioned by the unique values of a separate column
- [SUMIF](/cascade/functions-and-expressions/functions/aggregate/sumif.md): Sums values within a column if specified criteria is met
- [VAR](/cascade/functions-and-expressions/functions/aggregate/var.md): Calculates variance
- [VARP](/cascade/functions-and-expressions/functions/aggregate/varp.md): Calculates a population variance
- [VARS](/cascade/functions-and-expressions/functions/aggregate/vars.md): Calculates a sample variance
- [RUNNINGTOTALBY](/cascade/functions-and-expressions/functions/aggregate/runningtotalby.md): Calculates a running total when grouped by a partition column
- [SIGN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sign.md): Determines the sign of a number
- [SIN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sin.md): Calculates the sine of an angle
- [SQRT](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/sqrt.md): Takes the square root of a given number
- [SQUARE](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/square.md): Squares a given number
- [TAN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/tan.md): Calculates the tangent of an angle
- [ZN](/cascade/functions-and-expressions/functions/aggregate/runningtotalby/zn.md): Fill all null values with 0
- [Conversion Functions](/cascade/functions-and-expressions/functions/conversion.md)
- [TIMESTAMPTODATE](/cascade/functions-and-expressions/functions/conversion/timestamptodate.md): Converts a timestamp into a date/time value
- [TODATE](/cascade/functions-and-expressions/functions/conversion/todate.md): Converts text into a date/time value
- [TODECIMAL](/cascade/functions-and-expressions/functions/conversion/todecimal.md): Converts text into a decimal number
- [TOINT](/cascade/functions-and-expressions/functions/conversion/toint.md): Converts text into an integer
- [Date/Time Functions](/cascade/functions-and-expressions/functions/date-time.md)
- [DATEADD](/cascade/functions-and-expressions/functions/date-time/dateadd.md): Adds or subtracts a specific number of time steps from a date
- [DATEDIF](/cascade/functions-and-expressions/functions/date-time/datedif.md): Calculates the number of time steps between two dates
- [DATENAME](/cascade/functions-and-expressions/functions/date-time/datename.md): Returns text corresponding to the specified part of a given date
- [DATENORMALIZE](/cascade/functions-and-expressions/functions/date-time/datenormalize.md): Converts times to midnight
- [DATEPART](/cascade/functions-and-expressions/functions/date-time/datepart.md): Returns the specified part of a given date
- [DATETRUNC](/cascade/functions-and-expressions/functions/date-time/datetrunc.md): Truncates a date to the beginning of the specified period
- [DAY](/cascade/functions-and-expressions/functions/date-time/day.md): Calculates the day of the month for a given date
- [DAYS](/cascade/functions-and-expressions/functions/date-time/days.md): Calculates the number of days between two dates
- [HOUR](/cascade/functions-and-expressions/functions/date-time/hour.md): Calculates the hour corresponding to a date/time value
- [ISDATE](/cascade/functions-and-expressions/functions/date-time/isdate.md): Determines if a given date is a valid date
- [ISOWEEKDAY](/cascade/functions-and-expressions/functions/date-time/isoweekday.md): Returns the ISO8601 weekday of a given date
- [ISOWEEK](/cascade/functions-and-expressions/functions/date-time/isoweek.md): Returns the ISO8601 week of a given date
- [ISOQUARTER](/cascade/functions-and-expressions/functions/date-time/isoquarter.md): Returns the ISO8601 quarter of a given date
- [ISOYEAR](/cascade/functions-and-expressions/functions/date-time/isoyear.md): Returns the ISO8601 year of a given date
- [MAKEDATE](/cascade/functions-and-expressions/functions/date-time/makedate.md): Create a date/time value from a given year, month, and day
- [MAKEDATETIME](/cascade/functions-and-expressions/functions/date-time/makedatetime.md): Create a date/time value from a given date and time
- [MINUTE](/cascade/functions-and-expressions/functions/date-time/minute.md): Calculates the minute corresponding to a date/time value
- [MONTH](/cascade/functions-and-expressions/functions/date-time/month.md): Calculates the month for a given date
- [NOW](/cascade/functions-and-expressions/functions/date-time/now.md): Returns current timestamp on local system
- [QUARTER](/cascade/functions-and-expressions/functions/date-time/quarter.md): Returns the quarter of a given date
- [SECOND](/cascade/functions-and-expressions/functions/date-time/second.md): Calculates the second corresponding to a date/time value
- [TODAY](/cascade/functions-and-expressions/functions/date-time/today.md): Returns the current date
- [WEEK](/cascade/functions-and-expressions/functions/date-time/week.md): Calculates the week for a given date
- [WEEKDAY](/cascade/functions-and-expressions/functions/date-time/weekday.md): Converts a date into an integer corresponding to a day of the week
- [YEAR](/cascade/functions-and-expressions/functions/date-time/year.md): Calculates the year for a given date
- [Logical Functions](/cascade/functions-and-expressions/functions/logical.md)
- [AND](/cascade/functions-and-expressions/functions/logical/and.md): Returns true if all items are true, otherwise returns false
- [BETWEEN](/cascade/functions-and-expressions/functions/logical/between.md): Determines if given value is between two boundary values
- [CASE](/cascade/functions-and-expressions/functions/logical/case.md): Returns specified values when condition is met
- [CHOOSE](/cascade/functions-and-expressions/functions/logical/choose.md): Finds the value located at a specified index
- [CONTAINSWITHIN](/cascade/functions-and-expressions/functions/logical/containswithin.md): Returns true if the given value exists within a column or list of values.
- [IF](/cascade/functions-and-expressions/functions/logical/if.md): Tests whether expression is true or false and returns desired values accordingly
- [IFS](/cascade/functions-and-expressions/functions/logical/ifs.md): Implements multiple if-then statements simultaneously
- [IIF](/cascade/functions-and-expressions/functions/logical/iif.md): An if-then statement with capability of returning a third, unique value if condition is null
- [IN](/cascade/functions-and-expressions/functions/logical/in.md): Returns true if the given value exists within a column or list of values.
- [IFNULL](/cascade/functions-and-expressions/functions/logical/ifnull.md): Returns values dependent on if input values are null or not
- [ISBOOLEAN](/cascade/functions-and-expressions/functions/logical/isboolean.md): Determine if given values are boolean
- [ISDECIMAL](/cascade/functions-and-expressions/functions/logical/isdecimal.md): Determine if given values are decimals
- [ISDURATION](/cascade/functions-and-expressions/functions/logical/isduration.md): Determine if given values are durations
- [ISINTEGER](/cascade/functions-and-expressions/functions/logical/isinteger.md): Determine if given values are integers
- [ISNULL](/cascade/functions-and-expressions/functions/logical/isnull.md): Returns true for null values and false otherwise
- [ISNUMBER](/cascade/functions-and-expressions/functions/logical/isnumber.md): Determine if given values are numbers
- [ISSTRING](/cascade/functions-and-expressions/functions/logical/isstring.md): Determine if given values are strings
- [ISUNIQUE](/cascade/functions-and-expressions/functions/logical/isunique.md): Determines if the values in a column are unique
- [NOT](/cascade/functions-and-expressions/functions/logical/not.md): Returns true when a condition is false and false otherwise
- [NULL](/cascade/functions-and-expressions/functions/logical/null.md): Returns null value
- [OR](/cascade/functions-and-expressions/functions/logical/or.md): Returns true if any of multiple conditions are true, otherwise returns false
- [SWITCH](/cascade/functions-and-expressions/functions/logical/switch.md): Switches values with new values if original value matches key
- [ALL](/cascade/functions-and-expressions/functions/logical/all.md): Determine if all elements of a column are true
- [TOSTRING](/cascade/functions-and-expressions/functions/logical/all/tostring.md): Convert a value into a string
- [ANY](/cascade/functions-and-expressions/functions/logical/any.md): Determine if any elements of a column are true
- [Math Functions](/cascade/functions-and-expressions/functions/math.md)
- [ABS](/cascade/functions-and-expressions/functions/math/abs.md): Calculates the absolute value of a number
- [ACOS](/cascade/functions-and-expressions/functions/math/acos.md): Calculates the arc cosine of a number
- [ASIN](/cascade/functions-and-expressions/functions/math/asin.md): Calculates the arc sine of a number
- [ATAN](/cascade/functions-and-expressions/functions/math/atan.md): Calculates the arc tangent of a number
- [ATAN2](/cascade/functions-and-expressions/functions/math/atan2.md): Calculates the arc tangent of an ordered pair
- [CEILING](/cascade/functions-and-expressions/functions/math/ceiling.md): Rounds a given number up
- [COS](/cascade/functions-and-expressions/functions/math/cos.md): Calculates the cosine of an angle
- [COT](/cascade/functions-and-expressions/functions/math/cot.md): Calculates the cotangent of an angle
- [COSEC](/cascade/functions-and-expressions/functions/math/cosec.md): Calculates the cosecant of an angle
- [DEGREES](/cascade/functions-and-expressions/functions/math/degrees.md): Converts radians to degrees.
- [DIV](/cascade/functions-and-expressions/functions/math/div.md): Returns the integer portion of a division operation
- [EVEN](/cascade/functions-and-expressions/functions/math/even.md): Rounds a number up to the nearest even integer
- [EXPONENTIAL](/cascade/functions-and-expressions/functions/math/exponential.md): Exponential function
- [FILLINFINITY](/cascade/functions-and-expressions/functions/math/fillinfinity.md): Replace infinity values within input value
- [FLOOR](/cascade/functions-and-expressions/functions/math/floor.md): Rounds a given number down
- [HAVERSINE](/cascade/functions-and-expressions/functions/math/haversine.md): Calculates Haversine distance between coordinates
- [LOG](/cascade/functions-and-expressions/functions/math/log.md): Logarithm function
- [LN](/cascade/functions-and-expressions/functions/math/ln.md): Natural logarithm function
- [ODD](/cascade/functions-and-expressions/functions/math/odd.md): Rounds a number up to the nearest odd integer
- [MODULO](/cascade/functions-and-expressions/functions/math/modulo.md): Calculates the remainder of a division operation
- [PERCENTILEOFVALUE](/cascade/functions-and-expressions/functions/math/percentileofvalue.md): Calculate percentiles based on data
- [PERCENTILEVALUE](/cascade/functions-and-expressions/functions/math/percentilevalue.md): Calculate value(s) from specified percentiles
- [PI](/cascade/functions-and-expressions/functions/math/pi.md): Returns the PI value
- [POWER](/cascade/functions-and-expressions/functions/math/power.md): Raises a number to a specified exponent
- [RADIANS](/cascade/functions-and-expressions/functions/math/radians.md): Converts degrees to radians.
- [RANDOM](/cascade/functions-and-expressions/functions/math/random.md): Returns a random value between 0 and 1
- [ROUND](/cascade/functions-and-expressions/functions/math/round.md): Rounds a number or list of numbers
- [SEC](/cascade/functions-and-expressions/functions/math/sec.md): Calculates the secant of an angle
- [Table Functions](/cascade/functions-and-expressions/functions/table.md)
- [ENCODE](/cascade/functions-and-expressions/functions/table/encode.md): Returns integers for each unique string value in a referenced column.
- [INDEX](/cascade/functions-and-expressions/functions/table/index.md): Returns the value at a given index inside a column.
- [INDEXBY](/cascade/functions-and-expressions/functions/table/indexby.md): Returns a value of a specific index within a column, partitioned by the unique values of a separate column
- [FILLNULL](/cascade/functions-and-expressions/functions/table/fillnull.md): Fills null values with specified replacement value
- [FIRSTBY](/cascade/functions-and-expressions/functions/table/firstby.md): Finds the first element within a column, partitioned by the unique values of a separate column
- [GENERATEUNIQUEID](/cascade/functions-and-expressions/functions/table/generateuniqueid.md): Generates Unique IDs
- [LASTBY](/cascade/functions-and-expressions/functions/table/lastby.md): Finds the last element within a column, partitioned by the unique values of a separate column
- [LOOKUP](/cascade/functions-and-expressions/functions/table/lookup.md): Returns a row offset a given number of rows from the current row
- [MATCH](/cascade/functions-and-expressions/functions/table/match.md): Returns the index of a matched value
- [NTH](/cascade/functions-and-expressions/functions/table/nth.md): Returns the nth element of a given column
- [OFFSET](/cascade/functions-and-expressions/functions/table/offset.md): Offsets values within a column
- [OFFSETBY](/cascade/functions-and-expressions/functions/table/offsetby.md): Offsets values within a column, partitioned by the unique values of a separate column
- [PREVIOUSVALUE](/cascade/functions-and-expressions/functions/table/previousvalue.md): Calculate a function's result based on the previous row's values
- [RANK](/cascade/functions-and-expressions/functions/table/rank.md): Returns the rank of each element in a column
- [RANKBY](/cascade/functions-and-expressions/functions/table/rankby.md): Ranks values within a column, partitioned by the unique values of a separate column
- [RECORDID](/cascade/functions-and-expressions/functions/table/recordid.md): Generates IDs for each row in a table
- [ROLLINGAVERAGE](/cascade/functions-and-expressions/functions/table/rollingaverage.md): Calculates the rolling averages of a column
- [ROW](/cascade/functions-and-expressions/functions/table/row.md): Returns the current row number
- [RUNNINGAVERAGE](/cascade/functions-and-expressions/functions/table/runningaverage.md): Calculates the running average of a column
- [RUNNINGMAX](/cascade/functions-and-expressions/functions/table/runningmax.md): Calculates the running maximum of a column
- [RUNNINGMIN](/cascade/functions-and-expressions/functions/table/runningmin.md): Calculates the running minimum of a column
- [RUNNINGSTDEV](/cascade/functions-and-expressions/functions/table/runningstdev.md): Calculates the running standard deviation of a column
- [RUNNINGTOTAL](/cascade/functions-and-expressions/functions/table/runningtotal.md): Calculates the running total of a column
- [WINDOWAVERAGE](/cascade/functions-and-expressions/functions/table/windowaverage.md): Calculates rolling or static window average
- [WINDOWMAX](/cascade/functions-and-expressions/functions/table/windowmax.md): Calculates rolling or static window maximum
- [WINDOWMIN](/cascade/functions-and-expressions/functions/table/windowmin.md): Calculates rolling or static window minimum
- [WINDOWCOUNT](/cascade/functions-and-expressions/functions/table/windowcount.md): Calculates rolling or static window count
- [WINDOWSUM](/cascade/functions-and-expressions/functions/table/windowsum.md): Calculates rolling or static window sum
- [SEQUENCE](/cascade/functions-and-expressions/functions/table/sequence.md): Create a sequence of numeric values
- [WINDOWMEDIAN](/cascade/functions-and-expressions/functions/table/windowmedian.md): Calculates rolling or static window median
- [WINDOWSTDEV](/cascade/functions-and-expressions/functions/table/windowstdev.md): Calculates rolling or static window population standard deviation
- [WINDOWSTDEVP](/cascade/functions-and-expressions/functions/table/windowstdevp.md): Calculates rolling or static window population standard deviation
- [WINDOWSTDEVS](/cascade/functions-and-expressions/functions/table/windowstdevs.md): Calculates rolling or static window sample standard deviation
- [WINDOWVAR](/cascade/functions-and-expressions/functions/table/windowvar.md): Calculates rolling or static window average
- [WINDOWVARP](/cascade/functions-and-expressions/functions/table/windowvarp.md): Calculates rolling or static window average
- [WINDOWVARS](/cascade/functions-and-expressions/functions/table/windowvars.md): Calculates rolling or static window sample variance
- [WINDOWCORR](/cascade/functions-and-expressions/functions/table/windowcorr.md): Calculates rolling or static window average
- [WINDOWCOVAR](/cascade/functions-and-expressions/functions/table/windowcovar.md): Calculates rolling or static window population covariance
- [WINDOWCOVARP](/cascade/functions-and-expressions/functions/table/windowcovarp.md): Calculates rolling or static window average
- [WINDOWCOVARS](/cascade/functions-and-expressions/functions/table/windowcovars.md): Calculates rolling or static window sample covariance
- [SMOOTHEDAVERAGE](/cascade/functions-and-expressions/functions/table/smoothedaverage.md): Calculates the smoothed averages of a column
- [Text Functions](/cascade/functions-and-expressions/functions/text.md)
- [ASCII](/cascade/functions-and-expressions/functions/text/ascii.md): Returns the ASCII code for a given character
- [CHAR](/cascade/functions-and-expressions/functions/text/char.md): Returns the character for a given ASCII code
- [CONCAT](/cascade/functions-and-expressions/functions/text/concat.md): Concatenates all inputs into a string
- [CONTAINS](/cascade/functions-and-expressions/functions/text/contains.md): Checks if a given column contains specified text
- [ENDSWITH](/cascade/functions-and-expressions/functions/text/endswith.md): Determines whether a given string ends with a specified substring
- [FIND](/cascade/functions-and-expressions/functions/text/find.md): Finds the index of a substring within a string
- [FINDNTH](/cascade/functions-and-expressions/functions/text/findnth.md): Returns the nth occurrence of a substring within a string
- [ISEMPTY](/cascade/functions-and-expressions/functions/text/isempty.md): Determines if value(s) are empty strings
- [JSONPARSE](/cascade/functions-and-expressions/functions/text/jsonparse.md): Extracts a single field from a json
- [LEFT](/cascade/functions-and-expressions/functions/text/left.md): Returns a certain numbers of characters within a string, counting from the left
- [LENGTH](/cascade/functions-and-expressions/functions/text/length.md): Returns the number of characters within a given text
- [LOWER](/cascade/functions-and-expressions/functions/text/lower.md): Returns a string, converted to lowercase
- [LTRIM](/cascade/functions-and-expressions/functions/text/ltrim.md): Removes leading whitespace
- [MID](/cascade/functions-and-expressions/functions/text/mid.md): Returns a portion of input text beginning at specified location
- [PROPER](/cascade/functions-and-expressions/functions/text/proper.md): Convert text strings to proper case
- [RIGHT](/cascade/functions-and-expressions/functions/text/right.md): Returns a certain numbers of characters within a string, counting from the right
- [RTRIM](/cascade/functions-and-expressions/functions/text/rtrim.md): Removes trailing whitespace
- [SPACE](/cascade/functions-and-expressions/functions/text/space.md): Produces desired number of spaces
- [SPLIT](/cascade/functions-and-expressions/functions/text/split.md): Split a string based on a given delimiter
- [STARTSWITH](/cascade/functions-and-expressions/functions/text/startswith.md): Determines whether a given string begins with a specified substring
- [TRIM](/cascade/functions-and-expressions/functions/text/trim.md): Removes leading, trailing and repeated whitespace from a text string
- [SUBSTITUTE](/cascade/functions-and-expressions/functions/text/substitute.md): Substitutes all instances of one value with another value
- [UPPER](/cascade/functions-and-expressions/functions/text/upper.md): Returns a string, converted to uppercase