Add Field

On the main screen, the system allows to add a new field

Click on Add Field:

The system will display a screen to register the field data:

Field Name: Inform the name that will be assigned to the field. A good practice is to include field information in the name.
Data Type: Select the type of data that will be used in the field (String, Number and date)

A brief description of the field types:
- String: Represented by alphanumeric characters (letters, numbers and special characters) that can be used in the field.
- Number: Represents quantitative information that can be measured and counted. Often used to perform mathematical operations and statistical analyses.
- Date: Represents information related to the date that can be used in the field.
Description: Inform a brief description of the field that will be created.

Data Connectors: When working with Data Connectors, only those selected below will be listed
- Inform the data connector that will be used. This is an optional field.

Dataset: When in datasets, list only those selected below
- Select the dataset that will be used. By default, the system will use all of them if none are selected. It will only work for the workspace that is linked to the selected dataset. This is an optional field.

Define SQL: Inform the SQL expression that will be used to form the calculated field.

By clicking on the format button "", it is possible to indent the code, making it easier to read.

Note: When using a calculated field within another calculated field, you should use a colon before using double quotes. For example: SUM(:"pier/aws/fieldname":)