I've been trying to add automatic column with py script, but without a success. So the idea is to lets say i have a table like below:
| Date | A | B |
| 1-2021 | 13 | 20 |
| 2-2021 | 13 | 40 |
| 3-2021 | 26 | 100 |
| 4-2021 | 52 | 20 |
| 5-2021 | 52 | 200 |
| 6-2021 | 104 | 1000 |
And the idea is to create a additional column which tells us a current situation of A or B value over time, so basically something like this: ( let's say that 7-th month data is updated)
| Date | A | B | Comment |
| 1-2021 | 13 | 20 | - |
| 2-2021 | 13 | 40 | A did not change & B increased by 100%(or A did not change and B increased from 20 to 40) |
| 3-2021 | 26 | 100 | A increased by 100% & B increased by 150%(or from 40 to 100 etc.) |
| 4-2021 | 52 | 19 | A shows an upwards trend over last 3 months & B decreased X and is at its lowest point this year (or over last X months) |
| 5-2021 | 52 | 200 | ... |
| 6-2021 | 104 | 1000 | A & B increased and shows uptrend over last X months |
| 7-2021 | 208 | 2000 | A & B increased by X and shows uptrend over last X months |
Did anyone took similar approach to something like above? Looking for a suggestions & approach ideas or some solutions to problem above. A & B columns could also be like A (as value) and B as value category.
Thanks in advance!
