Hi All Greetings for the second time today! I'm on a roll. I've created the dashboard in the screen grab using Qotilabs Rich Filters v1.21.1. It's still a work in progress however after posting here I've managed to understand how Jira works and how the current sprint, future sprint and backlog issue counts are calculated. So firstly thanks to everyone that's replied to my previous posts! I'd like to use the Rich Filter Smart Gauges Gadget to visualise a count of the created date by ranges e.g.: * Issues created from Now() and -10 days * Issues created between -10 days and -20 days * Issues created between -20 days and -30 days * Issues created between -30 days and -50 days * Issues created between -50 days and -75 days * Issues created greater than -75 days This 6 gadget cluster will provide a useful insight into the aging of the issues being added to the current and future sprints, and provide the same with the larger backlog issues (in terms of ageing) when the backlog is selected from the Rich Filter Controller Gadget. You'll appreciate that if I use an absolutely date range then the filter will need changing, so it has to be a relative date range. Is there any method of doing this please? As usual, thanks to anyone that takes the time to respond. Stay holy, happy & healthy! Regards Hardip

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Rich Filter - Date Range

Hardip Singh_io6n6h

Hi All

Greetings for the second time today! I'm on a roll.

I've created the dashboard in the screen grab using Qotilabs Rich Filters v1.21.1. It's still a work in progress however after posting here I've managed to understand how Jira works and how the current sprint, future sprint and backlog issue counts are calculated.

So firstly thanks to everyone that's replied to my previous posts!

LAS Dashboard.png

I'd like to use the Rich Filter Smart Gauges Gadget to visualise a count of the created date by ranges e.g.:

Issues created from Now() and -10 days
Issues created between -10 days and -20 days
Issues created between -20 days and -30 days
Issues created between -30 days and -50 days
Issues created between -50 days and -75 days
Issues created greater than -75 days

This 6 gadget cluster will provide a useful insight into the aging of the issues being added to the current and future sprints, and provide the same with the larger backlog issues (in terms of ageing) when the backlog is selected from the Rich Filter Controller Gadget.

You'll appreciate that if I use an absolutely date range then the filter will need changing, so it has to be a relative date range.

Is there any method of doing this please?

As usual, thanks to anyone that takes the time to respond.

Stay holy, happy & healthy!

Regards

Hardip

Accepted answers

Craig Nodwell_7eve9b

Hi @Hardip Singh it sounds and looks like you're making great progress. Jira has some great internal date functions. Have a look at this page.

All comments

Craig Nodwell_7eve9b

Hi @Hardip Singh it sounds and looks like you're making great progress. Jira has some great internal date functions. Have a look at this page.

Craig Nodwell_7eve9b

And this one as well .

advanced-searching-functions-reference

Hardip Singh_io6n6h

Hi @Craig Nodwell

Thanks for the encouraging words and for sharing the link. I have reviewed the page. It's a very helpful resource in many ways. I managed to get the first query working, though that is the easiest one of all e.g. Project = XXX AND created > "-10d"

I then struggled with the between dates as per my example above. Unfortunately my JQL skills are adequate (at the very best) and need some improvement!

Are there any examples that can be provided. There is one example of relative date searches in the advanced search page however the between examples have no relative operators. <sad face>

I can't seem to get my head around it e.g. for issues created between -10 days and -20 days I'm assuming that I'd need something like:

Now()
Determine the date on the 11 day
Do the relative between function -11 to -20 days (which I can't do - see limited JQL admission above :-( )

Thanks for replying, its always appreciated.

Regards

Hardip

Craig Nodwell_7eve9b

you're welcome how about something like (sorry not sitting with an env open to test if this is right or not)
created > startOfDay("-20") AND created < startOfDay("-10")
Lots of date functions to play with.

Obinna.Chukwudum

Hi @Hardip Singh , I am trying to replicate your "issues Changes" gadget of the dashboard you shared in rich filter. what JQL did you use to get issues added to an open sprint?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jira-data-center