You have the ability to create a custom column in your data sets to create a custom column, and you can define custom expressions. Let's explore how to do that.
Lets look at the following example. Where you want to create a custom column called "Amount in Canadian Dollars"
First you have to select the data set "Borrows"
Locate the "Show Editor" button and click on it. This will open the editor interface.
Look for an option or tab to add a custom column. Click on it to proceed.
You'll find a text field where you can enter your formula. To convert an existing amount into Canadian dollars, the formula is given below in a screenshot Then provide a suitable name for your custom column, such as "Amount in CAD"
Once you have entered the formula and named the custom column, click the "Done" or "Apply" button to save the changes.
By following these steps, you can create a custom column and utilize custom expressions to manipulate and visualize your data more customized and meaningfully.