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 · Accepted solution]

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

[Aryeh Schwob]

Thanks for responding,
The dashboard gadgets only allow you to show status for  but I need to filter it further by time range so I can see what percentages of the tasks in the past 2 weeks got completed. To do that I'm trying to create a filter and then apply that filter to the gadget.