Display all issues where work logged exceeded estimate

Problem

As a project manager, you may encounter challenges in tracking issues where the logged work exceeds the original estimate. Understanding the reasons behind estimation discrepancies is crucial for future accuracy in project estimation. Additionally, identifying developers consistently surpassing expectations or budgets is essential for effective project management.

This article guides you through achieving these objectives using Power Scripts™ for Jira, a robust scripting tool designed to automate Jira processes.

Solution

This script is straightforward. By inputting a project through the advanced JQL search bar, the script scans all issues, computes time logged by group for each issue, and compares it to the original estimate. If the work logged exceeds the original estimate, the script returns the relevant issues via JQL.

Prerequisites

1. Ensure you have Jira Core or Jira Software installed.

2. Power Scripts™ for Jira should be installed.

3. Users should be categorized into groups labeled "jira-developers" and "jira-administrators." Adjustments may be necessary based on your specific requirements.

Copy or Create File in Root silprograms Directory

The following JQL script returns all issues with more work logged than the original estimate for a user-supplied project.

string [] keys = selectIssues("project = " + argv[0]);
string [] ret;
for(string k in keys) {
    if(%k%.originalEstimate !="") {
        interval developerTimeSpent = getTimeSpent(k, "jira-developers");
        interval administratorTimeSpent = getTimeSpent(k, "jira-administrators");
        interval totalTimeSpent = developerTimeSpent + administratorTimeSpent;
        if(totalTimeSpent > %k%.originalEstimate) {
            ret += k;
        }
    }
}

Execute the JQL

In the advanced JQL search bar, simply input and customize the following (adjusting the project key to your specific needs).

key in silJQLList("silJQL_LoggedGreaterThanEstimate.sil", "PROJ")