# Table Functions - [ENCODE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/encode.md): Returns integers for each unique string value in a referenced column. - [INDEX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/index.md): Returns the value at a given index inside a column. - [INDEXBY](https://docs.cascade.io/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](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/fillnull.md): Fills null values with specified replacement value - [FIRSTBY](https://docs.cascade.io/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](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/generateuniqueid.md): Generates Unique IDs - [LASTBY](https://docs.cascade.io/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](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lookup.md): Returns a row offset a given number of rows from the current row - [MATCH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/match.md): Returns the index of a matched value - [NTH](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/nth.md): Returns the nth element of a given column - [OFFSET](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offset.md): Offsets values within a column - [OFFSETBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/offsetby.md): Offsets values within a column, partitioned by the unique values of a separate column - [PREVIOUSVALUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/previousvalue.md): Calculate a function's result based on the previous row's values - [RANK](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rank.md): Returns the rank of each element in a column - [RANKBY](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rankby.md): Ranks values within a column, partitioned by the unique values of a separate column - [RECORDID](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/recordid.md): Generates IDs for each row in a table - [ROLLINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/rollingaverage.md): Calculates the rolling averages of a column - [ROW](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/row.md): Returns the current row number - [RUNNINGAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningaverage.md): Calculates the running average of a column - [RUNNINGMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmax.md): Calculates the running maximum of a column - [RUNNINGMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningmin.md): Calculates the running minimum of a column - [RUNNINGSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningstdev.md): Calculates the running standard deviation of a column - [RUNNINGTOTAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/runningtotal.md): Calculates the running total of a column - [WINDOWAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowaverage.md): Calculates rolling or static window average - [WINDOWMAX](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmax.md): Calculates rolling or static window maximum - [WINDOWMIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmin.md): Calculates rolling or static window minimum - [WINDOWCOUNT](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcount.md): Calculates rolling or static window count - [WINDOWSUM](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowsum.md): Calculates rolling or static window sum - [SEQUENCE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/sequence.md): Create a sequence of numeric values - [WINDOWMEDIAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowmedian.md): Calculates rolling or static window median - [WINDOWSTDEV](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdev.md): Calculates rolling or static window population standard deviation - [WINDOWSTDEVP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevp.md): Calculates rolling or static window population standard deviation - [WINDOWSTDEVS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowstdevs.md): Calculates rolling or static window sample standard deviation - [WINDOWVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvar.md): Calculates rolling or static window average - [WINDOWVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvarp.md): Calculates rolling or static window average - [WINDOWVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowvars.md): Calculates rolling or static window sample variance - [WINDOWCORR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcorr.md): Calculates rolling or static window average - [WINDOWCOVAR](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovar.md): Calculates rolling or static window population covariance - [WINDOWCOVARP](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovarp.md): Calculates rolling or static window average - [WINDOWCOVARS](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/windowcovars.md): Calculates rolling or static window sample covariance - [SMOOTHEDAVERAGE](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/smoothedaverage.md): Calculates the smoothed averages of a column --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.cascade.io/cascade/functions-and-expressions/functions/table.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.