3 Replies Latest reply on Jan 29, 2019 2:36 PM by Zhouyi Zhang

    JIRA - Calculate how long it takes for an issue to go from one status to another.

    Imran Ahmed

      Hi, I am trying to build a dashboard where I can display how much time it is taking a JIRA issue to be completed. For example, I am trying to figure out how many days it takes for an issue to go from status "Ready for Work" to status "Completed". As you can see in the below data, it took around 6 days for issue A123 to go from status "Ready for Work" to status "Completed" (1/28/2018 - 1/22/2018). How can I calculate this information in Tableau? 

          

      Issue IDIssue StatusStatus DateCreated Date
      A123New1/20/20181/20/2018
      A123In Grooming1/21/20181/20/2018
      A123Ready for work1/22/20181/20/2018
      A123In Progress1/23/20181/20/2018
      A123Completed1/28/20181/20/2018