Hello, im trying to get the periods between the changes has been made.
I have 1 row for every change (1st pic) with the date when it happens but I need to make them with the fromdate and todate (2nd pic).
The problem there (2nd pic), is that i need to know for example, from 30/11/2020 to 3/12/2020 the status id was 3 AND the assignee in that period is 5f107....