https://community.splunk.com/t5/Splunk-Search/Calculate-active-Sprint/m-p/544434#M154201 <P>Hi,</P><P>How to create a query to show&nbsp;Active Sprint(JIRA) with Start and end date in my splunk dashboard.<BR />I dont have fields with Sprint details<BR />Fields which i have are&nbsp;<BR />IssueCreated<BR />IssueUpdated<BR />ProjectID<BR />IssueType eg; story,bug , task</P><P>Status eg:,to do,done, inprogress<BR /><BR />Can someone help to create a splunk query for the same</P><P>&nbsp;</P> Fri, 19 Mar 2021 04:47:54 GMT Nith1 2021-03-19T04:47:54Z https://community.splunk.com/t5/Splunk-Search/Calculate-active-Sprint/m-p/544434#M154201 <P>Hi,</P><P>How to create a query to show&nbsp;Active Sprint(JIRA) with Start and end date in my splunk dashboard.<BR />I dont have fields with Sprint details<BR />Fields which i have are&nbsp;<BR />IssueCreated<BR />IssueUpdated<BR />ProjectID<BR />IssueType eg; story,bug , task</P><P>Status eg:,to do,done, inprogress<BR /><BR />Can someone help to create a splunk query for the same</P><P>&nbsp;</P> Fri, 19 Mar 2021 04:47:54 GMT https://community.splunk.com/t5/Splunk-Search/Calculate-active-Sprint/m-p/544434#M154201 Nith1 2021-03-19T04:47:54Z https://community.splunk.com/t5/Splunk-Search/Calculate-active-Sprint/m-p/544564#M154243 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/231928">@Nith1</a>,</P><P>You can use below as a sample;</P><LI-CODE lang="markup">| search NOT Status="done" | stats earliest(IssueCreated) as IssueCreated latest(IssueUpdated) as IssueUpdated by ProjectID IssueType</LI-CODE> Fri, 19 Mar 2021 19:08:36 GMT https://community.splunk.com/t5/Splunk-Search/Calculate-active-Sprint/m-p/544564#M154243 scelikok 2021-03-19T19:08:36Z