Date Ranges

[Scott Clifford]

Hello,

We have created some dashboards but rather than having to go in and edit each week using the custom date range which only allow you to look backwards.

i.e. today's date is July 26th and I want my dashboard to work from July 25th through to July 29th but you get an error stating that it cant be ahead of July 26th - any thoughts?

If anyone has used the gadgets to do this, happy to work with them,

Thanks

Scott

[Mark Segall · Accepted solution]

Hi @Scott Clifford and welcome to the community!

You'll want to update the filters behind your dashboard to use relative dates.  For example, this would get you everything from the start of week to this Friday:

created >= startOfWeek() and created < startofWeek(6d)

[Scott Clifford]

Thank you @Mark Segall I'm very very new to JIRA :-) so picking my way around things. Does this work even if we haven't got to Friday as I have just tried it and counts back from today for the last 7 days (including today)

[Walter Buggenhout]

Mark's example just considers the current week. If you want to filter dynamically from this moment, you can do something like this instead:

created >= Now(-7d) AND created <= now()

That would give you a rolling window between 7 days ago and the current moment. The basic principle remains the same.

[Scott Clifford]

Thanks @Walter Buggenhout