Hi KNIMERS, please how do i create the rate of increase for this Data

i was able to generate column B,C,D. The “increase Rate” Column was generated by this method

(B3-B2)/B2 MULTIPLY BY 100

i would appreciate the solution

Thanks

Hi KNIMERS, please how do i create the rate of increase for this Data

i was able to generate column B,C,D. The “increase Rate” Column was generated by this method

(B3-B2)/B2 MULTIPLY BY 100

i would appreciate the solution

Thanks

i mean, i need the node to calculate column D

Thanks

Use Lag Column and then Math Formula nodes. In the future, please attach data, so someone trying to help you doesn’t have to type it in.

4 Likes

worldwide-aggregate_csv.csv (33.2 KB)

i did not get the solution, attached is the document, can you explain further

What’s the exact problem you’re having?

Here’s the workflow with your data.

1 Like

seems like you are lacking paranthesis “(”

(x-y) / y

br

2 Likes

Thank you

Correct now

Thank you

now solved

@ajisafeadeoye I had no idea what your workflow looks like. I provided you with a simple example to show you how to use the Lag Column node. @Daniel_Weikert is right.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.