add Previous Month and Previous Quarter to time range filter

Gethro Guerrier December 16, 2022

How can i add Previous Month and Previous Quarter to time range filter in Jira project

1 answer

1 accepted

1 vote
Answer accepted
Sid Pathirana
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 17, 2022

Hi - are you looking to add the tickets from the previous month/quarter based on a particular criteria (eg. add tickets CREATED in previous month/quarter, add tickets RESOLVED, add tickets where priority was CHANGED, etc)?.

Using tickets RESOLVED as an example, you can include the following clause in your filter query:

Previous month:

resolved >= startOfMonth(-1) and resolved <= startOfMonth()


Previous quarter:

resolved >= startOfMonth(-3) and resolved <= startOfMonth()
Gethro Guerrier December 17, 2022

Hi Sid, i just want to update duration in a Jira reports for a specific project. manager needs to add previous Month and Previous Quarter to time range filter.

I am looking to add some additional time duration to the report time filter. Currently we have only below which are extended to the Service Project report.

See below on the default time range options I have as on today.Metric.png

Sid Pathirana
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 17, 2022

@Gethro Guerrier - do you have more details about the filter that is currently used in this report?

Gethro Guerrier December 20, 2022

Please see the note above

Sid Pathirana
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2022

Hi @Gethro Guerrier - ahh, I can see from your screenshot that you’re referring to the built-in JSM reports rather than something in Jira Software.

 

  • Don’t the standard options in the JSM report to show the data by <Past 30 days>, <Past quarter by day> or <Past quarter by week> get you close to what you need?

    Capture.JPG

 

  • Otherwise, would the <Custom range> option give you what you need, eg. last quarter example below?

 

Capture2.JPG

 

Or maybe a dashboard? This can pull in the standard JSM chart gadgets and also gadgets like the Created vs Resolved chart - a combination of these and the JQL filters behind should also give you what you need.


Capture3.JPG

Gethro Guerrier December 21, 2022

hey @Sid Pathirana  these answers are great and i like the options you proposed. Let me work with my employee and see if these options are good enough for him to do what he needs.

Gethro Guerrier January 2, 2023

@Sid Pathirana the custom range is not available on the JSM gadgets when imported to a dashboard. From the below screenshot, you would see that we just have the pre-set dates. I would like to have a preset Last Month and Last Qtr. My assumption is It should be configurable and more options could be added.ticket metrics.png

Sid Pathirana
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 2, 2023

For the JSM "Created vs Resolved" dashboard gadget, I think the gadget configuration will be restricted to just the options displayed in your screenshot. I'm not aware of any way to customize these options.

However, since the available options do include "Past 30 days" and "Part quarter by day/week" would your requirements be satisfied by adding two of the "Created vs Resolved" JSM gadgets to the dashboard and configuring one with the "Past 30 days" options and the other with the "Part quarter by day/week" option?

For anything not covered by the available gadget configuration options, you could perhaps create a custom filter and apply that to the standard "Created vs Resolved chart" dashboard gadget.

Suggest an answer

Log in or Sign up to answer