Repurposing calculations (custom columns)

Data Sources

Having different members of your organization creating metrics and running “standard” calculations often results in unreliable numbers. Custom Columns are a way to remove the possibility of different members of an org redefining metrics in different ways.

In this example, we want everyone in the org calculating discounted prices the same way.

  1. Click Data Sources next to the search bar and choose a data source. From the schema tab, open a table and click Add Custom Column.

    Click Add Custom Column under the Schema tab of a data source

  2. Define the discount calculation using SQL and name the column. This is a simple calculation, but Custom Columns can handle any SQL functions that your database uses.

    Define the custom column

Related Data Sources Help Articles

See more