How can I found time calculation between two status of Jira Issue in Qliksense

[ajayvermaida]

@sunny_talwar  @hic @swuehl @Gysbert_Wassenaar @rwunderlich @Michael_Tarallo 

Hi All

In one of Qliksense requirement I have to show the time difference between two status of same jira Issue.

for example 

Jira ID	Jira Status	Start Time	End Time
123	Open	16-03-2020	17-03-2020
123	In progress	17-03-2020	18-03-2020
123	Pending	18-03-2020	20-03-2020
123	Closed	20-03-2020	20-03-2020

above example I have choose very few status of Jira but in am app I have to use all the statuses which system have and give the filter to user so that on basis of that they can select one status time in between them to see the total time   for example if one can want to see the total time spent from Open to Pending  or Pending to close etc

can anyone help me how I can build my data model (which table I have to use and how I can link it) to fulfill this requirement currently I am showing currently status of Jira only in my app

Thanks

Ajay

[rwunderlich]

https://qlikviewcookbook.com/2013/07/calculating-a-duration-using-two-rows/

-Rob

[ajayvermaida]

Thanks for your quick response @rwunderlich  . but I want to show the Issue history from Jira start to end .

there is a tab Transition which contains the Jira history . please check the attached image

could yo please help me to achieve this requirement .