Page Comparison

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, and the script scans all issues, calculates computes time logged by group for each issue, and compares it to the original estimate. If the work logged is greater than exceeds the original estimate, it is returned the script returns the relevant issues via JQL.

Prerequisites

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

2. You have Power Scripts™ for Jira for Jira should be installedYour users are in groups titled .

3. Users should be categorized into groups labeled "jira-developers" and "jira-administrators." . You may need to tweak this for Adjustments may be necessary based on your specific needsrequirements.

Copy or Create File in Root silprograms Directory

This is a The following JQL script that will return returns all issues that have 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, you would simply type this (and tweak simply input and customize the following (adjusting the project key to your specific needs).

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