Display dynamic dimension movement per ID over time?

simon20 — Wed, 27 May 2020 12:57:02 GMT

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.

topic Display dynamic dimension movement per ID over time? in App Development

Display dynamic dimension movement per ID over time?