Hi, I have the following table for exemple
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).