# Overview of Formula Builder

Formula Builder is an interactive user interface that enables you to quickly create, test, and save formulas. Formulas enable you to create new columns of data that do not already exist in the dataset. For example, you can create a formula to segment data, aggregate data, calculate ratios, and much more. Once a formula is created and saved, it is available in Chart Builder, Pixel-perfect Reports, and the Analyze widget as a new column that can be added to a chart or visualization. The Qrvey platform computes the values of that column in real time, when the end user displays the chart or visualization.

For a video tutorial on using Formula Builder, see the video Formulas and Buckets.

Formula Builder is opened from within Chart Builder, Pixel-perfect Reports, or the Analyze widget. Click the sigma icon on the toolbar:

The Formulas dialog displays with a list of existing formulas.

To create a new formula, click **Create Formula**. The Create Formula dialog displays.

Formula Builder provides the following two modes for creating formulas:

**Data Engine Syntax (legacy)**. Create formulas using a database-specific syntax. For more information, see Using Data Engine Syntax Mode.**Standardized Syntax**. Create formulas using a standardized syntax that is compatible with any database connected to the Qrvey platform. Introduced in Version 8.2. For more information, see Using Standardized Syntax Mode.

## The Formula Builder Interface

The Formula Builder interface consists of three main sections:

**Formula**. The editor in which you write the formula.- Standardized Syntax also provides a
**Testing**tab, which enables you to define the input data to test your formula. For more information, see Using Standardized Syntax Mode. - Data Engine Syntax provides a
**Test**link that tests the formula using random values from the dataset.

- Standardized Syntax also provides a
**Insert Functions**. Lists all the functions available to use in your formula, provides a helpful description of each function, and enables you to add functions to the formula.**Insert Columns**. Lists all the dataset columns available to add to your formula.

## Using Formulas

After creating and saving a formula, it displays in the Data panel along with the other columns in the dataset. Formulas are indicated by the sigma icon before the name. You can select and use formulas in the same manner as other columns in various features including charts, filters, Automation, and Pixel-perfect Reports.

The following screenshot of Chart Builder includes several formulas in the Data panel:

See also: