add Previous Month and Previous Quarter to time range filter

[Gethro Guerrier]

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

[Sid Pathirana · Accepted solution]

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]

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.

[Sid Pathirana]

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

[Gethro Guerrier]

Please see the note above

[Sid Pathirana]

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?
  
  

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

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.

[Gethro Guerrier]

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]

@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.

[Sid Pathirana]

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.