Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Report

Ayush Lawania
Contributor
June 5, 2023

Hey, I need to create a report to display item which are due by 30,60 and 90 days, I know we can build a custom count in filter count gadget, but how to write the jql code to achieve this.

Ps: i need three counts for 30, 60 and 90 days.

2 answers

0 votes
Danut M _StonikByte_
Atlassian Partner
June 5, 2023 edited

Hi @Ayush Lawania,

Once you create the filters based on the JQL provided by @Trudy Claspill, you could use our Great Gadgets app to make those numbers visible on your dashboard.

One of the many gadgets that this app offers is the Advanced Issue Filter Formula gadget, that allows applying math formulas (count, percentages, etc) on the issues from up to 6 filters.

image.png

Clicking one one the numbers displayed, will open the corresponding filter with the issues.

This app offers many other gadgets that you will find useful.

 

Thank you,

Danut M.   

0 votes
Trudy Claspill
Community Champion
June 5, 2023

Hello @Ayush Lawania 

In the JQL you would compare the Due Date field to a number of days.

Do you want to find the items that are due in exactly 30 days, 60 days, and 90 days from today, or do you need to find the items due between now and 30 days from now, between 30 and 60 days from now, and between 60 and 90 days from now?

To find items due exactly 30 days from now use a JQL like this:

"Due Date" = 30d

To find items that are due between 30 and 60 days from name use this:

"Due Date" > 30d and "Due Date" < 61d

For more information on filtering refer to this document:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

Ayush Lawania
Contributor
June 6, 2023

Actually I need to see the task which were suppose to be completed earlier but are due now and I wanna see those tasks which are due by 30 days, 60 days and 90 days

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events