Data from many sources often comes in as ugly, or raw or is only readable by computers. Calculated columns allows you to do math between two or more fields, change the format of a date, or extract a substring to display valuable information on your table charts. You can do this without knowing SQL, or using custom fields in the data source.

If you want to use a pivot table or group your data, you'll need to create your calculated columns beforehand.

Creating Calculated Columns
To create a new calculated column, click on the calculator icon in the data transformation bar.

Give your new column a name. 

In the next field, start typing an expression for your new column. Grow will guess what you are typing and show you options for columns or functions you can use. 

If you use an expression (such as the ones listed below), red text will appear below the expression field. These are suggestions for what it expects the next part of the expression should be. If you have any errors in your expression, they will appear there, too.

If you need to stitch two strings or pieces of text together, you can concatenate them in calculating columns. This is done by using || in between the strings you would like to concat. If you want to see more detail on this, check out our help article on it.

Once you have added a calculated column, click done and your new column will be there. And that’s it!

Expressions in Calculated Columns
Calculated columns can handle order of expressions (things inside parenthesis are done first etc) as well as all the standard math functions. + - / *

Here is a list of supported expressions you can use while creating your custom calculations:

  • Expression: gt(value1, value2) 
  • Description: This returns TRUE if the first argument is greater than the second, and FALSE otherwise. Equivalent to the > operator.
  • Expression: gte(value1, value2)
  • Description: Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator.
  • Expression: lt(value1, value2)
  • Description: Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator.
  • Expression: lte(value1, value2)
  • Description: Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator.
  • Expression: count(value1, value2)
  • Description: Gives you the count of data for value 1. In this expression, additional values or ranges (such as value 2) may be added.
  • Expression: round(value, # decimal places)
  • Description: Rounds the numbers from the column you specify to the number of decimal places you choose.
  • Expression: substring(string, starting point, ending point)
  • Description: Returns the substring from the values you specify.
  • Expression: DateFormat(field, format)
  • Description: This will show you the date in a different format.
  • Expression: RegexExtract(/regular expression/, {column name})
  • Description: Extracts matching substrings according to a regular expression.
  • To understand better how to use RegexExtract in Grow's environment, check out our help article here.

Much of the info above was pulled from this Google help article. Check it out if you want to find out a little more about some of these expressions.

Questions? Let us know at support@grow.com or chat in on the site.

Did this answer your question?