Flag/merge rows with a parameter

  • 4 October 2021
  • 0 replies

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


0 replies

Be the first to reply!