Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate time between rows with specific ID and columns values

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.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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)

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak ,

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