Estimated reading time: 9 minutes

The following pages are tagged with

Title Page Summary
Calculate date formulas Calculating date formulas is useful when you want to compare data from different date periods. Here are some examples of using date formulas: Example 1 The following example shows you how to create formulas that you can use to compare data from this week to last week. The...
Calculate percentages Calculating percentages is useful when you want to see, for example, the percentage revenue generated from each channel (online, stores, partner, etc.). Here is a common percentage example: Example The following example shows you how to figure out the percentage revenue generated from each channel (online, stores, partners, etc.)....
Formula operators Formula operators allow you to apply if/then/else conditions in your formulas. You can leverage operators in your formulas to have them return true, false, or a predetermined value. Formula operators The operators include: ...
About date formulas Date functions are useful when you want to compare data collected between two date periods. Date formulas allow you to apply date related functions to your formulas. Date formulas The date formulas include: Function Description...
Percent (simple number) calculations You can use simple number functions to perform useful percent calculations. Simple number functions include addition, subtraction, multiplication, and division. Function Description Examples * Returns the result of multiplying...
Cumulative functions Cumulative formulas are aggregate formulas.
Filter on null, blank, or empty values Filtering on NULL and empty values is a special case.
Understand filters Filters narrow down the search result to only include the data you want to see.
Formula support for chasm trap schemas You can create a formula that involves aggregated measures coming from multiple fact tables of a chasm trap. Just as you would create any other formula, you can create a formula that spans across a chasm trap. The Formula Builder will...
Moving functions Moving formulas are aggregate formulas that allow you to calculate the average, max, min, or sum of your data over a predetermined interval, or window, with ...
Nested formulas Nested formulas, or formula on formula, allow you to reference a formula within another formula. This graphic illustrates how you would define a formula and then reference it from another: These formulas become columns, and are even suggested within the Formula Builder....
Group aggregation functions What if you want to aggregate a value by a specific attribute (for example, show revenue by product)? This is known as a grouped aggregation, but some people call it a pinned measure or level-based measure. You can do this for any aggregation using the grouping functions. Each of the...
Understand formulas in searches To provide richer insights, you can add a formula to your search.
Flexible aggregation functions (groups and filters) You can use the group_aggregate function to aggregate measures at granularities that are different from the dimensions that you have in columns used in the search. How aggregation formulas work Typically, the groupings and filters used in a formula will be the same as those of the columns...
Overview of aggregate formulas When working with formulas, it is useful to understand the difference between regular (or row-wise) formulas and aggregation formulas. Standard and aggregation formulas Formulas can be broken down into two types standard and aggregation formulas. Standard formulas act on individual rows and returns one result per row. Standard formulas...
Type conversion functions Some formulas require the input to be of a particular data type. If you find that you want to pass a value to the function, but it is of the wrong data type, you can convert it using a conversion formula. The following are the conversion formulas:
View or edit a formula in a search You can always go back and view or edit a formula that was added to a search. Do this by clicking the edit icon next to its name in the Columns listing. Anyone who has edit privileges on an answer can also edit any formulas it contains. To view or...
Add a formula to a search You can add a formula directly within a search. Some common reasons for using a formula in a search are to perform mathematical functions, check for and replace null values, or add conditional logic. How to add a formula To create a formula in a search: Start a...
Formula function reference 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...