Solved: Calculate active Sprint

Nith1 · ‎03-18-2021

Hi,

How to create a query to show Active Sprint(JIRA) with Start and end date in my splunk dashboard.
I dont have fields with Sprint details
Fields which i have are
IssueCreated
IssueUpdated
ProjectID
IssueType eg; story,bug , task

Status eg:,to do,done, inprogress

Can someone help to create a splunk query for the same

scelikok · ‎03-19-2021

Hi @Nith1,

You can use below as a sample;

| search NOT Status="done"
| stats earliest(IssueCreated) as IssueCreated latest(IssueUpdated) as IssueUpdated by ProjectID IssueType

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

scelikok · ‎03-19-2021

Hi @Nith1,

You can use below as a sample;

| search NOT Status="done"
| stats earliest(IssueCreated) as IssueCreated latest(IssueUpdated) as IssueUpdated by ProjectID IssueType

If this reply helps you an upvote and "Accept as Solution" is appreciated.

Calculate active Sprint

fields

lookup

Data Management Digest – December 2025

Index This | What is broken 80% of the time by February?

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Join the Conversation