Hi, I have the following table for exemple
Id | Status | Uptated_at |
---|---|---|
123 | 1 | 01.10.2021 |
123 | 2 | 02.10.2021 |
1234 | 1 | 1.10.2021 |
1234 | 3 | 1.10.2021 |
What I want is: flag all “ID” that had status “1” and count how many IDs I have that passed for status 1 and are in status 2 now.
My difficult to do this is because each status is saved in different rows. I already tried to use the measure ‘list’ but I’d like to use it like a dimension.
I thought in a solution to put all the status in the same row (like a json). It works in other table that I use (but the json comes native).