
Benefits of Derived Columns
Custom Metrics
Tailor your metrics to meet specific business needs.
Data Enrichment
Enhance your data by combining columns or applying calculations.
Real-Time Analysis
Perform calculations in real-time as your data updates.
Consistency
Ensure that everyone in your organization uses the same formulae and calculations for uniform reporting.
Steps to create calculated fields / derived columns ✨
Ensure Superjoin is installed and working before following the rest of the guide.
1
Open the "Data Preview" view
If you already have your desired source connected:
- Go to the
Sources
tab. - Click on the desired source.
- After clicking on the desired source, if you get an option to import / export the data, choose
Import
.
data preview
screen.Derived columns is only supported in our Chargebee and HubSpot Data Connector. If you wish to use this feature in any other integration, please write to us at support@superjoin.ai.

2
Click on "Add or Modify Fields"
Click on the 
Add or Modify Fields
button. This will open a sidebar where you can add / modify fields, and create calculated field(s) (derived columns).
3
Create a calculated field (Derived Column)
- Click on
Create calculated field
button. - Enter the
Field name
, this will be the name for the newly generated column. - Write a formula in the
Formula
section. You can use theFields
&Functions
tab to search for and select the fields and functions, respectively. - Once ready, click on
Add Field
.

4
Preview the Derived Column
After adding the field, the derived column would be visible as the last column in the preview.
You can add more derived columns.

5
Entering the edit mode
- In the
Add Fields
section, click onYour Calculated Fields
to expand it if not already. - Hover over the desired derived column title under the
Your Calculated Fields
to see an Edit option (Pencil Icon). - Click on the Edit option (Pencil icon) to edit the formula.
You can click
Delete
to delete the calculated field.
6
Modify or Delete the derived column
- Modify the formula as per needed.
- Click
Update
to update the derived column. - Click
Delete
to delete the derived column.

7
Preview the calculated field
The calculated field should now have updated.

The column will no longer exist if you chose to
Delete
the column.
8
Import the data
Click on 
Import
to import the data to a Google Sheet along with the derived column.