Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

How can I get a datediff based off the next logical row ?

I have the following table:   IssueKey      Status                        FirstTransitionTo ABC             Backlog                     1/1/2024 ABC             In Progress                1/15/20...
  • EaglesTony's avatar
    1 year ago

    I could try this.

     

    What I ended up doing was replicating the original table to other tables based off  Status and then did a group by the IssueKey and seems to work.