Add a formula to a search

Learn how to 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:

  1. Start a new search, or choose an existing Answer from a Pinboard to edit.

  2. If the Answer shows a chart, switch to Table View.

    Switch to table view
  3. In the upper-right side of the table, click the More icon icon more 10px and select Add formula.

    Create a new formula in an answer
  4. Name and enter your formula in the Formula Builder.

    Use the Formula Builder
    Formulas elements are color coded by type and can include the formula operators and functions (blue), the names of columns (purple), and/or constants (black).
  5. You can see a list of formula operators with examples by clicking Formula Assistant.

    Formula Assistant
  6. 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

    • Measure or attribute

    • Aggregation

    Advanced settings in the Formula Builder
  7. Name the formula by clicking its title and typing the new name. Click Save.