Skip to main content

 

ThoughtSpot

Create a Formula in a Worksheet

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

You can create a formula in a worksheet by using the Formula Builder. When you do this, the result of the formula gets added to the worksheet as a column.

Use these steps to create a formula:

  1. Create a New Worksheet, or edit an existing one.
  2. Click the + button next to Formula.
    File:02_Administration/Administrator_Guide_3.1/060/050/010/create_formula.png

    Create a new formula in a worksheet

  3. Type your formula in the Formula Builder.
    File:02_Administration/Administrator_Guide_3.1/060/050/010/formula_builder.png

    Use the Formula Builder

  4. If you want to change what your formula returns, use the Advanced settings.
    Depending on your formula, you may be able to change:
    • Data type
    • ATTRIBUTE or MEASURE
    • Aggregation type
    File:02_Administration/Administrator_Guide_3.1/060/050/010/formula_advanced_settings.png

    Advanced settings in the Formula Builder

  5. You can see a list of formula operators with examples by clicking on Formula Assistant.
    File:02_Administration/Administrator_Guide_3.1/060/050/010/formula_assistant.png

    Examples in the Formula Assistant

  6. Name the formlua by clicking on its title and typing the new name. Click Save.
  • Was this article helpful?