formula-reference.md

title	keywords	last_updated	sidebar	permalink
Formula function reference	tbd	tbd	mydoc_sidebar	/:collection/:path.html

ThoughtSpot allows you to create derived columns in worksheets using formulas. You create these columns by building formulas using the Formula Assistant. An individual formula is constructed from n combination of operators and functions.

This reference lists the various operators and functions you can use to create formulas.

Operators

{% include content/operators.md %}

Aggregate functions

These functions can be used to aggregate data.

{% include content/aggregate.md %}

Conversion functions

These functions can be used to convert data from one data type to another. Conversion to or from date data types is not supported.

{% include content/conversion-func.md %}

Date functions

{% include content/date-func.md %}

Mixed functions

These functions can be used with text and numeric data types.

{% include content/mixed-func.md %}

Number functions

{% include content/number-func.md %}

Text functions

{% include content/text-func.md %}