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<=""

[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