Great Gadgets
Great Gadgets
Breadcrumbs

Advanced Issue Filter Formula Gadget

On this page

Overview

This gadget allows displaying the result of up to 9 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 9 calculations results (instead of one), combines data from up to 9 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-20250611-120239.png


How does it work? The gadget lets you define up to 9 variables ('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', and 'i') 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 9 math formulas and display their results.

You can also use more advanced math functions, such as SQRT, LOG, ROUND and others. For a complete list of supported functions, please see https://ezylang.github.io/EvalEx/references/functions.html.

Configuration

The settings of this gadget are divided in 2 tabs:

  • Data tab - contains the required settings of the gadget, such as title or data source

  • More Settings tab - contains the optional settings, such as display mode and refresh interval.

Data tab

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

image-20250924-113549.png

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', 'f', 'g', 'h' or 'i' 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'.

Color Settings

You can customize the display color of the value by clicking the green square on the right side. By default, the value is shown in green, but you can choose any color to better suit your needs.

image-20250611-121912.png

Choose how the displayed results should be colored:

  • Fixed color - choose this option if you want to apply a fixed chosen color, regardless of the result value.

image-20250930-114010.png

  • Number colored by value - choose this option if you want to apply different colors to specified value ranges. In this case, you need to set custom limits and colors.

image-20250930-113651.png

If you check Extra highlight by coloring border, the gadget will color the border in the same color.

image-20250930-114205.png

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).

More Settings tab

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

image-20250523-061825.png

Setting

Description

Display mode

Choose how the formula results will be displayed.

As cards - check this option to display the results in a card format. Best for dashboards where you want to highlight and draw attention to key metrics.

image-20250529-083049.png


As inline text - check this option to display the results as simple text, which fits better in compact layouts like tables in Confluence.

image-20250523-063135.png

Refresh interval

Choose how often the gadget will refresh automatically.

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