Create Custom Columns

Purpose of Custom Columns:

Custom columns in Databrain enable users to create and save new data fields derived from their existing data. These columns are mathematically calculated, transformed, or altered to suit specific business needs. Once created, they can be reused across all metrics and analyses.

Example Use Cases:

• Combining fields: Merge first and last names into a "Full Name" column for consistent use across datasets.

• Standardizing calculations: Create a "Net Revenue" column by subtracting refunds and discounts from total sales, ensuring consistent formulas across reports.

• Defining business-specific KPIs: Calculate "Customer Lifetime Value" based on purchase frequency, average order value, and customer lifespan to track business performance.

1. Access Calculated Field:

In the metric creation page, hover over the "Measures" area and click on the "+fx" icon.

Databrain offers two methods for creating custom columns:

1. Quick Field: For simple calculations and basic metrics

   Use Cases:

   • Simple mathematical operations (e.g., addition, subtraction).

   • Basic business metrics (e.g., profit margins, conversion rates).

   • Standardized calculations across reports

2. Complex Field: For advanced calculations and data transformations

   Use Cases:

   • Advanced calculations with multiple conditions

   • Custom aggregations

   • Complex business logic implementation

Method 1: Quick Field

• Column Selection: Choose your input columns.

• Data Configuration: Set data type and then choose aggregate function.

• Operation Selection: Pick a mathematical operator (+ - * /).

• Assign an alias for the calculated field and click on "Save" to save the calculated field.

Method 2: Complex Field

• In the Metric Creation page, hover over the Measures area and click on the "+fx" icon.

• Select the target table name, then enter your SQL query in the code area.

• For the SQL query, please follow the syntax

  "schemaName_tableName"."columnName"

  Replace "schemaName_tableName" with your actual schema and table names.

• Assign an alias to the query and click "Add".

• Finally, "Save to Dashboard" to save the metric to the dashboard.

Once saved, the custom column is added to the specified table (e.g., "demo_sales") and is ready for use in any metric or analysis.

Here is an illustration of Generated SQL after adding the Custom SQL Column: