Issue Filter Formula

Overview

The gadget works in three layers. Understand the layers and the rest of the configuration is straightforward.

LayerWhat It IsHow Many
VariablesNamed aggregations over Jira issues, called a through i. Each has its own data source and JQLUp to 9
FormulasMath expressions over those variablesAs many as you need
DisplaysHow each formula's result is renderedOne mode per formula

A Worked Example

To show escaped defect rate - bugs found in production as a percentage of all bugs:

  1. Variable a: Count of work items, JQL type = Bug AND labels = production
  2. Variable b: Count of work items, JQL type = Bug
  3. Formula: a / b * 100, suffix %, 1 decimal
  4. Display: gauge, 0 to 100, green under 5, amber to 15, red above

The result is a single number your leadership can read, computed from two completely independent queries.

Why Separate Data Sources Matter

Each variable resolves its own scope. That means one formula can compare different projects, different time windows, or different issue types - something no single-query gadget can do.

ComparisonHow
This sprint vs. last sprintTwo variables, two sprint-scoped JQL queries
Team A vs. Team BTwo variables, two project or component scopes
Bugs vs. storiesTwo variables, two issue-type filters
Actual vs. targetOne variable plus a constant in the formula

Overview

FeatureDescription
9 VariablesNamed a to i, each independently scoped
5 AggregationsCount, Sum, Average, Minimum, Maximum
Full Function LibraryArithmetic plus rounding, logs, conditionals, and aggregate functions
4 Display ModesNumber, number colored by value, gauge chart, and star rating
Color RulesValue ranges that drive the color of the result
Card LayoutMultiple formulas laid out as cards in one gadget

Data Sources

Every variable supports Projects, Board, Saved Filter, Custom JQL, and Dynamic Filter Controller - chosen per variable, not once for the gadget.