Open defects at end of calendar week

[ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ]

I need a filter that will show number of open defects at end of calendar weeks past and future. E.g. end of calendar week 38, then 39, 40 etc

[ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ]

No, i don't want a histogram.

I have a table (in confluence) where i have my NUMBER OF DEFECTS OPEN PREDICTION model per week (from October till March) and i want to have a filter filling-in automatically in this table the NUMBER OF DEFECTS OPEN REAL number week over week.

[Valerie Knapp]

Hi @ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ , thanks for your question.

Have you started to write this query at all? Typically we would try to help you with something you are doing, rather than to write the JQL for you.

So, this is within a specific project? Only for the issue type of defect?

I think the JQL would be something like this -

project = "pkey" and type = Defect and statusCategory NOT IN (done)

It is likely you will need an app to have a histogram with bins for each week of the year. You can see what kind of filters / dashboard gadgets are available in an app like eazyBI here -

https://eazybi.com/accounts/1000/cubes/Issues/reports/2564718-resolved-and-hours-spent 

Best wishes