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

JIRA filter problem

Nunzio

Hi guys,

when doing a report for the last year on our project we get different statistics.
For the whole year we get 482 tickets.
When we go on each month we get the total 461.

The query used is for the whole year is:

project = ENT AND component = "02 - NETWORK" AND created >= 2018-12-01 AND created <= 2018-12-31 ORDER BY created ASC, updated DESC

The query used for each month is ( example for December ) :

project = ENT AND component = "02 - NETWORK" AND created >= 2018-12-01 AND created <= 2018-12-31 ORDER BY created ASC, updated DESC

What's wrong?

Thanks for you're help

Accepted answers

Mario Carabelli

@Nunzio

On the first view the queries look sound.

Can you send the other monthly queries.Than I can double check them.

Maybe you entered a wrong end of the month (30. instead of 31.) somewhere or got the logic wrong ( <= instead of if <) or something similar.

Regards

Mario

All comments

Christos Moysiadis

Hi @Nunzio,

can u use this ?

project = ENT AND component = "02 - NETWORK" AND created >= startOfMonth() AND created <= endOfMonth() ORDER BY created ASC, updated DESC

the above jql will count the issues of the current month though

& this

project = ENT AND component = "02 - NETWORK" AND created >= startOfYear() AND created <= endOfYear() ORDER BY created ASC, updated DESC

best regards

Answer update.... if you use the <= or >= you are "losing" some issues as i see.. try to use a JQL like

project = ENT AND component = "02 - NETWORK" AND created > "2018-11-30" and created < "2019/01/01" ORDER BY created ASC, updated DESC ...

Mario Carabelli

@Nunzio

On the first view the queries look sound.

Can you send the other monthly queries.Than I can double check them.

Maybe you entered a wrong end of the month (30. instead of 31.) somewhere or got the logic wrong ( <= instead of if <) or something similar.

Regards

Mario

Mario Carabelli

@Christos Moysiadis

You can use this jql functions with arguments to report on other months.

For example startOfYear(-1M) to mark the start of the last month in the last year.

But these functions are always dynamic or respectively relative to the system time.

But for the purpose of yearly reports I would actually go with @Nunzio queries. Just because you can use the same filters in a year and they will deliver the same results.

The error which must lay in some little detailand is independent of this aspect though.

Kind regards

Mario

Nunzio

Hi Christos,

thanks for you're reply.

Yes I can but how can help me these 2 query? I mean, the first one is for the current month and the second is for the current year.

I need to do a report of 2018

Can you help me?

Sorry if I bother you and thanks again

Nunzio

Hi Mario,

are the same.. I change just the date.

I've already done a check and I'm sure to don't type wrong end of the month.. to avoid this problem I've also used the basic mode to create the filter

Christos Moysiadis

@Mario Carabelli thank you for your note i didn't know that i could use -1... thats great!

Anyway i can not think another possibility ! ill check here and wait for your solution :P

Best regards

Mario Carabelli

Okay.

Then I don't know theanswer.

But you could try to isolate the excess issues in the yearly query with:

Filter = "name of the yearly filter" AND NOT (Filter ="name of january filfer" OR Filter = "name of february filter" OR...)

Maybe this can throw a spotlight on the underlying issue.

With kind regards

Mario

Nunzio

Thanks again Mario!

I've saved 3 filters:
1 - project = ENT AND component = "02 - NETWORK" AND created >= 2018-12-01 AND created <= 2018-12-31 ORDER BY created ASC, updated DESC

2 - project = ENT AND component = "02 - NETWORK" AND created >= 2018-01-01 AND created <= 2018-01-31 ORDER BY created ASC, updated DESC

3 - project = ENT AND component = "02 - NETWORK" AND created >= 2018-01-01 AND created <= 2018-12-31 ORDER BY created ASC, updated DESC

Below the result

I'm doing anything wrong

Thanks for your patience!!

Screenshot 2019-01-22 at 08.26.13.png

Welcome!

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

Quick Links

Find more posts tagged with

jira