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; } } }

Retrieving the number of closed tickets for each quarter in the year

Manish Shah_382uui

Hi All

I want to be able to retrieve the number of closed tickets within each quarter within the year.

I can use JQL:

project = "<project name>" AND resolved > "2022/01/01" AND resolved < "2022/03/31" AND status = Done

To make it specific for Q1.

This query would not work for next year:

project = "<project name>" AND resolved >= startOfYear() AND resolved < "2022/03/31" AND status = Done

Is there a way to work out the date range for the quarters dynamically? So, that it works regardless of the year we are in?

I've looked extensively at the date functions but can't figure out what to use!

Accepted answers

Jack Brickey

Try using "startofyear()"

Q1... resolutiondate >= startOfYear() and resolutiondate <= startofyear(-3M)

I think that is correct syntax

All comments

Jack Brickey

Try using "startofyear()"

Q1... resolutiondate >= startOfYear() and resolutiondate <= startofyear(-3M)

I think that is correct syntax

Craig Nodwell_7eve9b

Hi @Manish Shah I agree with Jack startOfYear()

Manish Shah_382uui

I thought if you use a minus then that would refer to the year before.

Let me try that.

But how do I dynamically resolve Q2 ...Q4 time periods??

Manish Shah_382uui

This gives Q1:

project = "<project>" AND resolved > startOfYear() AND resolved <= startOfYear(3M) AND status = Done ORDER BY resolved DESC

Manish Shah_382uui

So, for Qtr2 it would be something like:

project = "<project>" AND resolved <= startOfYear(6M) AND resolved >= startOfYear(3M) AND status = Done ORDER BY resolved DESC

Q3:

project = <"project"> AND resolved <= startOfYear(9M) AND resolved >= startOfYear(6M) AND status = Done ORDER BY resolved DESC

And finally Q4:

project = <"project"> AND resolved <= startOfYear(12M) AND resolved >= startOfYear(9M) AND status = Done ORDER BY resolved DESC

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud