Display dynamic dimension movement per ID over time?
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
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.