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.