Question

Flag/merge rows with a parameter

  • 4 October 2021
  • 0 replies
  • 5 views

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!

Reply