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.
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.
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.