App Development

[simon20]

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:

• One filter/variable where you set interval in months (>0). Note! I don't want to select a start point for the interval, so if no date selections is made it should compare all Dates with Date + X months.
• Based on above selections, visualize a sankey chart (or similar), where:
  • Dimension 1: Dim1 at period in "Date" column
  • Dimension 2: Dim2 at period in "Date" column + filter/variable selection
  • Measure: Distinct ID count

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.