Derived Columns
Derived columns are custom columns that you create within your Superjoin reports by applying formulas to your existing data. They allow you to manipulate and transform your data without altering the original dataset, enabling dynamic calculations and insights.
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 ✨
Open the "Data Preview" view
If you already have your desired source connected:
- Go to the
Sourcestab. - Click on the desired source.
- After clicking on the desired source, if you get an option to import / export the data, choose
Import.
If you need to setup a new integration, please follow the integration guide for the integration of your choice. You can find the guides for various integrations on the sidebar or on the integrations summary page.
Now you should see the 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.
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).
Create a calculated field (Derived Column)
- Click on
Create calculated fieldbutton. - Enter the
Field name, this will be the name for the newly generated column. - Write a formula in the
Formulasection. You can use theFields&Functionstab to search for and select the fields and functions, respectively. - Once ready, click on
Add Field.
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.
Entering the edit mode
- In the
Add Fieldssection, click onYour Calculated Fieldsto expand it if not already. - Hover over the desired derived column title under the
Your Calculated Fieldsto see an Edit option (Pencil Icon). - Click on the Edit option (Pencil icon) to edit the formula.
Delete to delete the calculated field.Modify or Delete the derived column
- Modify the formula as per needed.
- Click
Updateto update the derived column. - Click
Deleteto delete the derived column.
Preview the calculated field
The calculated field should now have updated.
Delete the column.Import the data
Click on Import to import the data to a Google Sheet along with the derived column.
Formula Glossary
Explore a comprehensive list of operators and functions to enhance your derived columns. The glossary includes essential mathematical, string, date, and logical functions, along with examples to help you create powerful formulae in Superjoin.
Was this page helpful?