I am currently working with a monthly snapshot customer data table, basically looking like this
ID | Date | Dim1 |
1 | 202001 | A |
1 | 202002 | B |
1 | 202003 | B |
What I need to achieve is some way to, on an ID level, see Dim1 movement over time. I visualize it like this:
To visualize it in a table, it would look something like this
Dim1 @date | Dim1 @date + X | Amount |
A | A | 3 |
A | B | 2 |
B | A | 5 |
B | B | 7 |
Optimally, I want to handle this in-app. The app has other flags and dimensions, and I am afraid that handling this in script would explode the row count.