How can I automate the weekly charts in custom charts?

[Julie Santiago]

Hi, 

I created a few widgets that are filtering weekly and I would like to automate the filter to update by its self instead of having to do it manually. Any thoughts? 

[Mark Higgins]

HI @Julie Santiago 

Welcome to the community!

Would you mind taking a screen shot of the filter, as I believe you should be able to use the inbuilt functions of JQL, such as startofweek(-1).

created >= startOfWeek(-1) order by created DESC

Cheers

Mark

[Julie Santiago]

createdDate < endOfWeek(-1) AND createdDate >= startOfWeek(-1)

[Julie Santiago]

@Mark Higgins  thanks for the warm welcome. I would like the query to update by itself without manually having to do so.... 

[Mark Higgins]

Hi @Julie Santiago 

I may be missing something here, but as time goes on, doesn't your query move with it?

So, you would like all the tickets from the 2nd last week, and then the last week.

That would indicate you would want the startofweek(-2) and then startofweek(-1)?

Pls feel free to tell me otherwise?

Cheers

Mark