I created a report & Dashboard using filters but I have 6 different project pages that need weekly reporting.
I am currently using a simple filter shown below to gather some data elements but the date range has to be manually updated every week for the dashboards and reports to work.
project = Enrollment and statusCategory = Done
AND resolved >= "2024/06/29" AND resolved <= "2024/07/06"
Is there a way to automate the date range?
Hello @Jasdeep Joga
Welcome to the Atlassian community.
Are you trying to show the information always for the current week, or the previous week, or ?
If you want to show the information for the current week plus the last day of the previous week (Saturday through Saturday) you could use this:
resolved >= startOfWeek(-1d) and resolved <= endOfWeek()
https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfWeek--
I am trying to find data from Friday to Thursday but I will look into sat to sat.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Would that be for the past Friday through the next upcoming Thursday?
If you want Friday through Thursday, inclusive, then use:
resolved >= startOfWeek(-2d) and resolved <= endOfWeek(-2d)
Sunday is the first day of the week for this function, and Saturday the last day of the week.
If you want to go from the last Friday that would be 2 days before Sunday (the startOfWeek day). If you want to go through the next upcoming Thursday that would be 2 days before Saturday (the endOfWeek day)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.