Calculate time between rows with specific ID and columns values

[Anonymous]

Hi, 

I have the following table: 

There are many different 'Issue Keys' , and for each, differen 'field name'.

What I am trying to calculate is the time difference (can be days/hours) between rows where the field name is 'Status', for each 'Issue Key'.  ( time should be calculated based on the 'change time' field)

How can I do this? 

Thanks.

[amitchandak · Accepted solution]

@Anonymous , a new column like, status filter need to be added

new column =
var _max = maxx(filter(Table, [Issue Key] = earlier([Issue Key]) && [change time] <earlier([change time])),[change time])
return
datediff(_max, [change time], second)

[Anonymous]

Hi @amitchandak ,

Thanks a lot, it actually worked better with 'MINX', but still wouldn't be able to get this without your help!