Once you’ve created a Dataset or Merged Dataset in Databox, you can take your analysis further by adding calculated columns. This allows you to build new Metrics directly within your Dataset—such as Close Rate, Conversion Rate, LTV to CAC Ratio, and more.
This is especially helpful when you want to manipulate or combine existing columns without needing to make changes in your original data source.
How to create a calculated column in a Dataset
Go to Data Manager and open either the Datasets or the Merged Datasets page.
Find your Dataset and click View Data, then click Edit Data.
On the right side, click the + icon to add a new calculated column.
Enter the formula by using the functions from the dropdown or by typing in a custom formula. You can reference any of the available columns from the Dataset.
PRO TIP: Reference columns using the dollar $ sign and typing their names, e.g. $Revenue, $Users etc.
Supported functions
You can use a wide range of predefined but also custom functions in your formulas, including:
Math & aggregation: SUM, AVG, COUNT, MIN, MAX, MOD, ABS, POWER, ROUND, CEILING, FLOOR, MEDIAN, STDEV, VARIANCE
Arithmetic operators: + (add), - (subtract), * (multiply), / (divide), // (integer division), % (modulo), ^ (exponent), ! (factorial)
Comparison operators: <, >, <=, >=, =, !=
Text: CONCAT, LEFT, RIGHT, LENGTH, TRIM, UPPER, LOWER, REPLACE, SUBSTRING, FIND, CONTAINS, STARTSWITH, ENDSWITH
Date/time: TODAY, NOW, YEAR, MONTH, WEEK, DAY, HOUR, DATEDIFF, DATEADD, QUARTER, WEEKDAY
Logical: AND, OR, NOT, IS NULL, IS NOT NULL
Conditional: IF, IFNULL, CASE WHEN ... THEN ... ELSE ... END
Once saved, your calculated column becomes a part of the Dataset and can be used just like any other Metric in Databoards or used to create new Data Calculations.
For more, visit: How to create a calculated column in a Dataset.