Need Project Filter Help YTD % projects completed

[Tim Langdon]

Hi there,

I am trying to build a dashboard for my team and I want to make a filter to use for the dashboard to display. I am trying to get the YTD % of projects completed (live date<=due date) by Assignee for all of the issue types we have. Can somebody help me write out this filter so it can pull the correct data to display on my dashboard.

[mauricio.groth · Accepted solution]

Hi @Tim Langdon 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your issues that the assignee is X and the live date <= duedate

issue in dateCompare("'live date'<='due date'") and assignee = X

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Mark Segall · Accepted solution]

Hi @Tim Langdon and welcome to the community!

Unfortunately, you cannot compare two date fields against each other in JQL.  Here are some options:

• Relative: Return all issues where Due Date was between 15 days and 5 days ago:

  •  dueDate >= startOfDay(-15) AND dueDate <= startOfDay(-5)

• Fixed: Return all issues where Due Date was between two fixed dates:

  • dueDate >= "2022/10/10" AND dueDate < "2022/10/25"

Here's some additional documentation on JQL:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-CreatedCreatedDatecreatedDateCreated