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.
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.
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.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.