Generate Attribute depending on 2 values in previous rows

MPB_

Hi there,

I already searched the forum but did not find anything very helpful.

Let´s say I have some easy sales-data in an example-set like this:

Week | Product | UnitPrice | Unit_Sales

01_19| Beer_A | 0.99 | 10

02_19| Beer_A | 0.85 | 20

I would like to generate a new Attribute which:

• either gives the price of a product of thelast week
  
• or already calulates the price-difference from the previous week to the actual row/week
  

Is that even possible with the operator Generate Attribute?

Best regards and have a nice day

MartinLiebig

Hi@MPB_

please have a look at the attached process. That should explain it.

BR,

Martin

MartinLiebig

Hi,

you most likely want to use first the Lag operator and combine this with Generate Attributes.

Cheers,

Martin

MPB_

Hi Martin, thank you for your answer.

Could you please explain that? How exactly would you lag this and how would you combine that with generate Attributes?

MPB_

Thank you very much Sir!!!!