KPI Formula, Trend & Big Number Dashboard Documentation

Plugio KPI Formula, Trend & Big Number Dashboard turns multiple JQL queries and numeric fields into a single, bold big number using your own mathematical formulas — then tracks it over time with period-over-period trend indicators. Build a dashboard of fully custom KPI cards on Jira, no two-app workarounds required.

Getting Started

Add the gadget to your Jira Dashboard in 5 steps:

1. 1 On your Jira Dashboard, click Add Gadget.
2. 2 Find "KPI Formula, Trend & Big Number Dashboard" and click Add.
3. 3 Click Configure on the gadget to open the editor.
4. 4 Add one or more metrics to the card — each is a JQL query plus an operation (count, sum, average…).
5. 5 Choose what to show — a single metric or a custom formula — then pick a number format and, optionally, a comparison period.

Metrics & JQL

Every card is self-contained: you define its data inside the card as one or more metrics, labelled A, B, C… Each metric is a single number you can show on its own or combine with the others in a formula.

Each metric has

• A JQL query that scopes the issues. It can span multiple projects, e.g. project in (PROJ1, PROJ2) — the gadget never forces a single-project constraint, so the scope is entirely up to your JQL.
• An operation: Count, Sum, Average, Min, or Max. Count works on the issue set; the others run over a chosen numeric field (story points, custom fields, time tracking…).
• A value source: a numeric field, or a derived value — Date difference (To − From), Days since a date, Days until a date, or Ratio (A ÷ B).

Date awareness

Mark a metric as date-aware and choose its date field to make it respond to the dashboard period. This is what lets a metric be compared period-over-period for trends (below).

Formula Engine

Under “Choose what to show” a card either shows a single metric directly or combines its metrics with a formula:

• Direct — display one metric as-is ({A}).
• Custom formula — combine the card’s own metrics with math, referencing them by label in curly braces.

Examples

• Completion % — {A}/{B}*100
• Net flow — {A}-{B}
• Points per developer — {A}/{C}

Formulas use the standard arithmetic operators (+ − × ÷) and parentheses, and reference only the metrics defined on the same card — keeping each card portable and easy to reason about.

Trends & Comparison

Trends aren’t written into a formula — you switch them on per card from the Comparison dropdown. The card then compares its current value to the previous equivalent period and shows a badge:

• No comparison — just the number.
• vs previous — % change — percentage delta, e.g. ▲14.3%.
• vs previous — absolute — raw difference, e.g. +12.
• vs previous — show previous — the previous period’s value alongside the current one.

A “lower is better” toggle flips the badge colours, so a drop in bugs or cycle time reads as positive (green) rather than negative.

Period

The dashboard period is set on the gadget by granularity — Day, Week, Month, Quarter, Year — with presets such as Last 30 days, This month, or Last quarter. The previous window is derived from it automatically (e.g. This month → last month), and that’s what every comparison measures against.

Note: a comparison only moves when the metrics it uses are date-aware. If a card compares against the previous period but its metrics aren’t date-filtered, the value stays flat — and the editor warns you.

Number Formatting

Render each result the way it reads best:

• Format — Number, or Duration for time-tracking fields.
• Decimals, plus an optional prefix and suffix (e.g. $, %, pts).
• Compact — abbreviate large numbers (e.g. 1.2k, 3.4M).

Titles & Labels

Each card follows a consistent anatomy: a title above the number and an optional description beneath it, so a wall of metrics stays scannable. Per-card accent colours and conditional colouring rules let you signal status.

Layout & Theming

Cards sit in a flexible Bento-style grid — place tiles of different sizes and the layout reflows to fit the gadget container as you resize it on your Jira dashboard.

Per-card color accents and conditional formatting let you signal status, and the gadget honors Jira's light and dark themes out of the box.

Support

Need assistance or have feedback? We're here to help.

Email: [email protected]