View All Docs
Product overview
Account overview
Integrations
Transforms
Security
Hide Navigation
Product overview
Account overview
Integrations
Transforms
Security
Transforms  

Add growth rate

The Add growth rate step calculates the growth rate from the previous row within a column of your choosing.

Input/output

The data we'll connect into this step shows us the change in a specific stock price over time.

Connecting input data to this step gives us a new 'Growth Rate' column, showing the percent change in stock price compared to the prior recorded date.

Custom settings

First, select the column that you'd like to calculate the growth rate of.

Then, under 'New Column Name', title your new column. In the 'Decimal Places' field, input the number of decimal places you want included in the calculation.

Finish by selecting the button 'Show Updated Results' to save and display your new output data. Your table now has a column inserted to the right of the column whose growth it's calculating. This new column will display the percent change from row to row, in decimal format.