Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am calculating a new date field based on the status in the load script like so
if(newstatus = 'In Review', Date(Date(transitiondate,'YYYY-MM-DD hh:mm:ss.f'))) as inreviewdate
However obviously this date field is only showing up for the row with that status (See picture).
How can I apply this date to all rows associated with that issue key so that i can fulfil a calculation for the 3rd row (in first table below), where I am subtracting the dates that and item went into review (inreviewdate) and when it was resolved .
In the second table, change num(inreviewdate) to num(transitiondate)