Articles on: Transforms

Insert growth rate column

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

Insert growth rate column





Input/output



The input data is a list of products.




After connecting input data to this step, it gives us the output of a newly added column called "Growth Rate" showing how much more or less of a product growth compared to the row above it.






Settings



First, Pick the dataset, then type the column name in "New Column Name" field, then type the "Target Column" name that you'd like to calculate the growth rate of.

After that, decide on how many decimal places you want included in the calculation and place this numeric value in the "Decimal Places" field.

Finish by clicking on "Preview results" to display the output data. The table now has a column inserted right. It will display the growth rate based off of the previous row. The results are percentages displayed in decimal format.


Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!