Display dynamic dimension movement per ID over time?
I am currently working with a monthly snapshot customer data table, basically looking like this
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