How do I use the calculate a new column filter?
If you need to create a column using data from an existing column, you can use the Add Table Filter > Alter Column Structure > Calculate a New Column filter:
In order to cite a column you wish to work with, you can either use default 'Col #' or the custom column names you use via the Add Table Filter > Alter Column Structure > Name Column Headers filter:
Using default column names
Using named columns
This filter is flexible and supports all basic math operations, addition (+), subtraction (-), multiplication (*), and division (/), and supports order of operations by using parenthesis in your calculation:
If you have any questions or run into trouble getting set up please reach out to us at firstname.lastname@example.org.