Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,535
Community Members
 
Community Events
176
Community Groups

add Previous Month and Previous Quarter to time range filter

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

1 answer

1 accepted

1 vote
Answer accepted

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()

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

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

Please see the note above

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

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.

@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

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
TAGS

Atlassian Community Events