Flag/merge rows with a parameter

[gabriel_lourenc]

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).