Advanced Issue Filter Formula Gadget

Owned by David Claudia
Last updated: May 14, 2024 by Danut M [StonikByte]
3 min read

On this page

https://youtu.be/_LAfgZgHqk0

Overview

This gadget allows displaying the result of up to 6 calculations of math formulas applied against the numerical fields or the count of the issues from multiple Jira filters. Comparing with the Issue Filter Formula Gadget, it allows displaying up to 6 calculations results (instead of one), combines data from up to six filters (instead of one) and can do more advanced calculations (not only SUM, COUNT, AVG, MIN or MAX). For example, you could use this gadget to calculate and display the percent of work done or the percent of budget spent.

image-20240315-094623.png

How does it work? The gadget lets you define up to 6 variables ('a', 'b', 'c', 'd', 'e' and 'f') calculated as COUNT, SUM, MAX, MIN or AVERAGE for a numeric field of the issues from a specified Jira issue filter. Then, you can combine these variables into up to 6 math formulas and display their results.

Configuration

On this tab you can configure the required settings of the gadget.

image-20240315-094825.png

Setting

Description

Setting

Description

Gadget Title

Choose what to display in the title bar of the gadget.

Variables

Select the variable(s) 'a', 'b', 'c', 'd', 'e' or 'f' that you need and specify how they are calculated. For each of them, choose the Formula (SUM, MIN, MAX, COUNT or AVG) that is applied against the selected Field of the issues returned by the selected Filter or JQL string.

  • On Jira Server and Data Center, the scripted fields added via the ScriptRunner app are also available for selection here, but only if they are configured as numerical fields in the Custom Fields area of Jira Administration. More exactly, their Search Template must be set to Number Search.

  • On Jira Service Management, select the Satisfaction field to calculate, for example, the average Customer Satisfaction (CSAT) based on the feedback provided by your customers after their ticket is closed.

Data To Display

Decide what numbers to display in the gadget by entering Math Formulas that combine one or more of the selected variables. For each formula, enter a Label and specify with how many Decimals the formula result shall be displayed.
Optionally, for each value displayed, you can specify a Prefix and/or Suffix of up to 10 chars representing the unit of measure. The prefix, for instance '$', will be displayed before the calculated value (ex. '$8500.50'), while the suffix, for instance '%', will be displayed after the calculated value (ex. '55.69%'). If you check Format with commas, values like '$8500.50' will be displayed like '$8,500.50'.

Example: Let's assume that you want to display the percent of work done (by story points) for a project. Here are the steps to perform:

  • You have to create two filters:

    • a filter that returns all the issues from the project.

    • a filter that returns only the issues from the project that are done.

  • Then, you have to define two variables:

    • 'a' that will be calculated as the SUM of Story Points field of the issues from the first filter. This represents the total estimated work, in story points.

    • 'b' that will be calculated as the SUM of Story Points field of the issues from the second filter. This represents the total amount of work done, in story points.

  • Finally, display the numbers by entering the following math formulas:

    • 'a' - to display the value of 'a' variable representing the total estimated work.

    • 'b' - to display the value of 'b' variable representing the total work done.

    • '(b / a) * 100' - to calculate and display the percent of work done

  • Proceed in the same way to calculate and display other project key-numbers.

The gadget displays 'NaN' (Not a Number) if the result of the formula cannot be calculated. This can happen in case of division by zero or when one of the variables cannot be calculated (for example, the AVG or MAX for a filter that returns no issues).

Related blog articles

The following blog articles provide more information on how to use this gadget.