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 organization redefining metrics in different ways.
In this example, we want everyone in the organization to calculate discounted prices the same way.
Click Data Sources next to the search bar and choose a Data Source. From the Schema tab, open the table where you want to add the column and click Add Custom Column.
Define the discount calculation using SQL syntax for your Data Source and name the column. This example uses a simple calculation, but Custom Columns can handle any SQL functions that your database uses.
Fill out the remaining fields depending on how you’d like your column’s output to be presented. Don’t forget to add a Description to let other users know what this column calculates. Once completed, click “Add Column”.
Your column will now be added to your Schema and be available to use in any Interactive Mode charts.
Take a look at the video below to see a step-by-step example of setting up a custom column:
<iframe width=“640” height=”360” src=”https://www.youtube.com/embed/cYOUPH_aFmI” frameborder=”0” allow=”accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture” allowfullscreen></iframe>