Issue Statistics per Week

[PavanKumar Nerella]

On every Monday, I need to submit the weekly report of the type of issues, and the number of issues, and their current status of the last 1 week. I would also need that data to be presented on a dashboard automatically every Monday along with previous weeks' data. (Eg: If we are in Week 31 as of now, I need the data of the last 8 weeks data).

I tried the below filter for the last 1 week data

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

How to get the same data for all the weeks periodically?

[John Funk · Accepted solution]

Hi @PavanKumar Nerella  - Welcome to the Atlassian Community!

You can create 8 filters like that and just change the -1 to -2 for the second one, -3 for the third one and so on. 

[PavanKumar Nerella]

Hello @John Funk 

Thanks for your response. I agree with your response but curious to know if we have the inbuilt keyword or functions in JQL to achieve this?