JQL Query for Summing Completed Story Points Per Assignee

In Agile methodologies, tracking the completion of story points per assignee is vital for assessing individual productivity and workload distribution. While Jira's built-in JQL (Jira Query Language) capabilities enable users to create detailed queries, summing up completed story points per assignee directly through JQL can be complex. This article will discuss the limitations of using JQL for this purpose and introduce the "Status & Progress Report" gadget from the "Simple Custom Reports, Charts & Time in Status for Jira" app as an effective solution.

Limitations of JQL for Summing Story Points

JQL is a powerful tool for querying issues in Jira based on various criteria. However, when it comes to aggregating data such as summing story points:

1. No Direct Aggregation: JQL does not natively support aggregation functions like SUM, which are needed to total story points.

2. Complex Workarounds: While it's possible to create complex workarounds using multiple filters and external tools, these solutions are not straightforward and can be time-consuming.

Solution with "Status & Progress Report" Gadget

To efficiently sum up completed story points per assignee, the "Status & Progress Report" gadget from the "Simple Custom Reports, Charts & Time in Status for Jira" app can be utilized. This gadget simplifies the process and offers a more user-friendly and integrated approach.

Installing the "Simple Custom Reports, Charts & Time in Status for Jira" App

1. Visit the Atlassian Marketplace: Go to the app's page.

2. Choose the Correct Version for Your Jira Instance: Select from Cloud, Server, or Data Center options.

3. Install the App: Click on "Get it now" or "Try it free."

Configuring the "Status & Progress Report" Gadget

1. Open Your Jira Dashboard: Navigate to 'Dashboards' in the Jira top menu and select your dashboard.

2. Edit Your Dashboard: Enter the editing mode by clicking on 'Edit'.

3. Add the Gadget: Select 'Add Gadget', then find and add the "Status & Progress Report" gadget.

4. Set Up the Gadget:

   • Configure the gadget to display completed story points.

   • Filter the results by an assignee to get individual totals.

5. Save and View: After setting up, save your dashboard. The gadget will display the sum of completed story points per assignee.

Benefits of Using the Gadget

• Simplified Process: This avoids the complexity of JQL for aggregating story points.

• Real-Time Data Visualization: Provides an up-to-date graphical representation of completed story points.

• Customizable Reporting: Allows for tailored reports based on specific project needs or team structures.

While JQL offers robust querying capabilities within Jira, it falls short in directly aggregating data like summing up completed story points per assignee. The "Status & Progress Report" gadget from the "Simple Custom Reports, Charts & Time in Status for Jira" app emerges as a valuable tool for this purpose, offering a straightforward and efficient way to gain insights into individual productivity. Integrating this gadget into your Jira dashboard can significantly enhance your ability to monitor and manage workload distribution and individual performance metrics.