(Custom) ? report to see tickets created before and during quarter

[Alexandre Brandt]

Hello there,

I'm pretty new to Jira. Using it as an end user (non-admin). I was able to create a dashboard using some available report templates. Is seems, however, that the templates are rather limited. 

What I need to see is a chart (any visualization will work) where I am comparing tickets (all types assigned to me) that are completed during the quarter. But I want to see two groups: tickets that were created before the quarter start and the tickets created during the quarter.

Is this something I can achieve within Jira or I need to pull the data in Excel and create such a chart in Excel?

Thank you,
Alexandre

[Jack Brickey]

Hi @Alexandre Brandt , welcome to the community.

You could create two separate filters one for prOOT to current quarter and one for current quarter. Then you can use these two filters in separate gadgets to illustrate the data you seek.

current quarter…

created >= startOfYear(9M)

prior to current quarter…

created < startOfYear(9M)

please note that JQL does not provide the concept of quarters. You can provide exact dates or periods relative to the start of the year, month, week, day, etc. so in the above example, I am doing it for the fourth quarter of the year by using the 9 month offset. 

[Alexandre Brandt]

Hello @Jack Brickey 

Thanks for the suggestion. Ok, I did not know it was possible to use a Filter as base for a Gadget. Good to know. 

Any documentation about how to do that?

[Jack Brickey]

Here are a few links...

perform-a-basic-search 

what-is-advanced-search-in-jira-cloud 

what-is-a-jira-dashboard 

let me know if you need further assistance.