a JQL for number of completed work over the time period

[Gaurav Pardeshi]

Hello,

I want to measure Issue completed over a time period for my ART and for last 3 PIs

I need a JQL which does that so that I can make filter and fetch it in pie chart

I have used these JQL but not having expected results as of now

Project ="ABC"AND issuetype = Epic and labels = PI.2426 AND worklogDate >= "2024/06/24" AND worklogDate<=""

I also tried Created>="" AND created<=""

[Alexey Pavlenko _App Developer_ · Accepted solution]

Hi @Gaurav Pardeshi ,

The correct expression you need to use in your JQL is 

resolutionDate >= "%PI_START_DATE%" AND resolutionDate =< "%PI_END_DATE%"

However, it requires manual maintenance.

For an automatic solution, you can use the app I developed - Multi-team Scrum Metrics & Retrospective. Look at the Completed Scope metric for the last 3 quarters (I assume 1 PI = 1 quarter in your case).

Best regards,
Alexey

[Gaurav Pardeshi]

Hello Alexey,

This looks great.

I will check if the app you developed can be integrated with my org JIRA.

And the query with resolution date doesn't work with me.

I tried many modifications with resolutions dates

[Gaurav Pardeshi]

project = "ABCD" AND issuetype = Epic AND labels = PI.2426 AND resolutiondate >= "2024/06/24"

works but inadaquate data 

[Alexey Pavlenko _App Developer_]

@Gaurav Pardeshi ,

Please describe the expected result.

Do you really need only epics with the label you specified?

  resolutiondate >= "2024/06/24" and resolutiondate <= "2024/09/01"  

should definitely work. If it returns nothing, then you don't have resolved issues for this period. If the query returns an error, the search field is highlighted in red and you get an error message beneath the search field.

Best regards,
Alexey

[Gaurav Pardeshi]

Hi Alexey,

this helps as I just checked it for other PI and I get value. I am verifying the numbers with CFD

I think this works

thanks alot for your helps.

BR
Gaurav

[Alexey Pavlenko _App Developer_]

@Gaurav Pardeshi ,

Cool, glad that it works now.

Best regards,
Alexey

[Gaurav Pardeshi]

Hi Marc, thanks for the response

I am aware about the JQL syntax, to specifics I tried the JQL like this,

the dates are clear but my question is it is not fetching the right data which i can use in the filter to show in pie chart

For eg

Project ="ABC"AND issuetype = Epic and labels = PI.2426 AND worklogDate >= "2024/06/24" AND worklogDate<="24/09/01"

project = "ABC" AND issuetype = Epic and labels = PI.2436 AND status changed to "In Progress" after '2024-09-01' 

I want to capture the issuetypes from the below CFD from the date range captured in green box

[Marc - Devoteam]

Hi @Gaurav Pardeshi 

Welcome to the community.

You will need to specify a dats or clause option like endOfDay on the second date option in the JQL.

example: worklogDate <= endOfDay() or worklogDate <= "2024/12/31"

You can't leave this empty like worklogDate <=""

[Marc - Devoteam]

Hi @Gaurav Pardeshi 

The green box is related to a status right?

Then add a clause related to the status to your JQL, status "Out of scope"

[Gaurav Pardeshi]

Hi Yes the green box

and the one of the status "out of scope" where very tiny possibility where issue travels from that.

but I try to do that as well

main thing is the statuses like in refinement, ready for planning,  out of scope, committed will get counted eventually in "In proress" from birdview level

thanks