How to create a report to display tasks with zero remaining hours for either the logged-in user or for individual users in Reports and Timesheets for Jira app

Owned by Priyal Jaiswal, created
Last updated: Sept 26, 2023 by Amith Mathur
2 min read

This article helps you to display a report having issues with zero remaining hours for either the logged-in user or for individual users in tabular view.

Instructions

Create a report to display tasks with zero remaining hours for the logged-in user:

  1. Select view type as List.

  2. Add fields Current Assignee: Name, Issue Key and summary, Time Entry: Logged time, Original estimate.

  3. Make sure the aggregate of the Original estimate is None as shown in the below screenshot.

     

  4. Write JQL as

remainingEstimate = 0 and worklogdate >= '2023-07-01' and assignee in (currentuser())

  1. Run the report.

  2. It displays the result for the currently logged-in user.



Create a report to display tasks with zero remaining hours for individual users:

  1. Select view type as List.

  2. Add fields Time Entry: User, Issue Key, and summary, Time Entry: Logged time, Original estimate.

  3. Apply filter to Time Entry: User as required. Here User is “Priyal Jaiswal”.

     

  4. Write a JQL:

remainingEstimate = 0 and worklogdate >= '2023-07-01'

 

  1. Make sure the aggregate of the Original estimate is None as shown in the below screenshot.

     

  2. Run the report.

  3. It now displays the result for the individual user - “Priyal Jaiswal”.

 

  • Make changes in JQL or fields as per specific requirements.