How to exract a report showing tasks completed and tasks not completed in time

[Daphne Wallen]

I am looking for help on how to create a report that is showing tasks completed over the past month and/or a separate report swowing tasks not completed in time, ie tasks that are still in progress or to do but are past their due date

[Florian Bonniec]

Hi @Daphne Wallen 

For completed task you can use a JQL on resolutionDate.

resolved >= startofMonth("-1") and resolved < startofMonth()

For In Progress stuff you can use operator was and issue not resolve.

status was "In Progress" DURING ("2010/01/01","2011/01/01") and resolution is empty

https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-operators/

Regards

[Daphne Wallen]

Sorry I don't think perhaps I was clear with what I am looking for.

Basically I want to create a report that shows all tasks that are past there due dates.

And rather thatn just setting it up as a board is it possible to extract a report as under tthe option to the left handside of the project where it says "Reports" I see there are a lot of possible reports but not one showing a view on missed due dates and completed  tasks versus non completed 

[Kateryna_v_SaaSJet_]

Hello @Daphne Wallen
Welcome to the community!

It may be easier for you to use the appropriate Marketplace plugin for this. Here is a link to a detailed article on how to make reports in Jira, but I recommend you try the SLA Time and Report add-on for Jira, which our company developed.
You can easily set up SLA configurations and some automation in it.

It generates reports of several types:

1) A table with a list of tasks showing how much time was spent on the solution (on time or with exceeded deadlines). You can choose any filters for display: by Assignee, date range, task statuses, etc.

2) 3 chart views (Met vs Exceeded, per Assignee, Pie Chart), where you can also set the desired filters and get a chart report, export it or share it via a link.

Use the 30-day trial to test for yourself how suitable it is for you.