https://community.fabric.microsoft.com/t5/Report-Server/How-to-display-JIRA-quot-Time-In-Source-Status-quot-in-Dashboard/m-p/665609#M10014 <P>Hi PowerBI community,</P><P>&nbsp;</P><P>I was running a business request that we want to track how much time spent on each status for each issue .</P><P>&nbsp;</P><P>In JIRA page, it actually will show "Time In Source Status" under "Transitions" tab<FONT color="#ff6600"> (see below screenshot).</FONT> However, I cannot find the "Time In Source Status" filed. Instead, JIRA data within PowerBI only shows "updated" and "statu.name". Those two variables are dynamic and the field value updates once status changes<FONT color="#ff6600">(See below screenshot).</FONT></P><P>&nbsp;</P><P>Do you guys know&nbsp;what&nbsp;I can do to&nbsp;get each status&nbsp;time for each issue? Ultimate goal is to break down the time for each status and look for business process improvement opportunity. I really appreciate your insights.</P><P>&nbsp;</P><P><img /><img /></P> Tue, 09 Apr 2019 15:41:02 GMT VivianX 2019-04-09T15:41:02Z https://community.fabric.microsoft.com/t5/Report-Server/How-to-display-JIRA-quot-Time-In-Source-Status-quot-in-Dashboard/m-p/665609#M10014 <P>Hi PowerBI community,</P><P>&nbsp;</P><P>I was running a business request that we want to track how much time spent on each status for each issue .</P><P>&nbsp;</P><P>In JIRA page, it actually will show "Time In Source Status" under "Transitions" tab<FONT color="#ff6600"> (see below screenshot).</FONT> However, I cannot find the "Time In Source Status" filed. Instead, JIRA data within PowerBI only shows "updated" and "statu.name". Those two variables are dynamic and the field value updates once status changes<FONT color="#ff6600">(See below screenshot).</FONT></P><P>&nbsp;</P><P>Do you guys know&nbsp;what&nbsp;I can do to&nbsp;get each status&nbsp;time for each issue? Ultimate goal is to break down the time for each status and look for business process improvement opportunity. I really appreciate your insights.</P><P>&nbsp;</P><P><img /><img /></P> Tue, 09 Apr 2019 15:41:02 GMT https://community.fabric.microsoft.com/t5/Report-Server/How-to-display-JIRA-quot-Time-In-Source-Status-quot-in-Dashboard/m-p/665609#M10014 VivianX 2019-04-09T15:41:02Z