Create Custom Columns
This guide offers a straightforward approach to creating custom columns by utilizing calculated fields and SQL queries, enabling users to tailor their data analysis to specific needs.
Last updated
This guide offers a straightforward approach to creating custom columns by utilizing calculated fields and SQL queries, enabling users to tailor their data analysis to specific needs.
Last updated
Using Calculated Fields
Access Calculated Field:
In the metric creation page, hover over the "Measures" area and click on the "+-*/" icon (Calculator icon)
Configure Calculated Field:
Column Selection: Choose your input columns.
Data Configuration: Set data type and then choose aggregate function.
Operation Selection: Pick a mathematical operator (+ - * /).
Enter descriptive name for the calculated field and click on "Save" to save the calculated field.
End Result:
Using SQL Queries
Access and configure SQL query:
In the Metric Creation page, hover over the Measures area and click the "SQL" icon (next to the calculated field icon).
Select the target table name, then enter your SQL query in the code area.
Assign a suitable name to the query and click "Add".
View the results:
An Illustration of Generated SQL: After Adding the Custom SQL Column
