JQL query to return all task status' with a specific label for the last 3 weeks

Aryeh Schwob

Hi,
I'm trying to write JQL query for all task status' with a specific label for the last 3 weeks not including the last day.

The current query that I have is 
project=project AND labels =label1 AND "Start date[]">= startOfWeek(-2) AND "start date[]" >= startOFDay(-1) ORDER BY status

How can I get this to work?

Thank you!

Kristján Geir Mathiesen

Hi @Aryeh Schwob 

If I understand you correctly, you want to see the workflow statuses of certain tickets (i.e. the ones your JQL returns). You can to this by clicking on Export from your JQL search (once you have the results). Scroll to the bottom and click on Create dashboard gadget. The choose the Pie Chart on the left. Clock on the small cog wheel above the cancel button and click on Edit. Now you can change the Statistics Type to Status and then click save. There is no need to Save to Dashboard, unless you really want to.

HTH,
KGM