Dashboard gadget: KPI stat tile

Description

Background

Single-value output for the approvals gadget: one aggregated number over the filtered, entitled set, for questions like "how many approvals await my decision", "my median response time", "my approve rate". This ticket specifies only the KPI tile type; common chart behaviour (fields, filters, visibility, measures) is inherited from the chart foundation. The tile has no Chart by and no Group by: it aggregates the whole set into one value, and is the building block for the personal decision-profile and at-risk stat cells.

KPI type

  • No Chart by and no Group by; the tile shows a single aggregated value over the filtered set.

  • Calculations drives the value: approval count by default, or any available measure (time to resolution, age, approval rate) with its aggregation function.

  • The value is rendered large with an editable caption, defaulting to the measure name.

Comparison (optional, off by default)

When enabled, the tile shows a delta beside the value, against one of:

  • Previous period: the same measure over the preceding period (e.g. this month vs last month).

  • Team baseline: the value compared to a baseline across all approvers in scope (e.g. the median), for personal tiles like the decision profile.

  • Static target: a configurable goal value with an editable label (e.g. an SLA of 24h, a 90% approve rate).

Trend color is configurable (up-good, up-bad, neutral), since up is good for some measures and bad for others. Delta can be absolute, percentage, or both.

Display options

  • Caption: editable, defaults to the measure name.

  • Number format: Auto or Compact; time measures shown readably with a configurable unit.

  • Comparison: off by default; base (previous period / team baseline / static target), delta form, trend-color direction.

  • Enable hyperlink: on by default; clicking the tile opens the approvals list with the tile's filters.

Acceptance criteria

  • The tile shows a single aggregated value over the filtered, entitled set, with no Chart by or Group by.

  • Calculations selects the measure and function (approval count by default).

  • The value is rendered large with an editable caption defaulting to the measure name.

  • Comparison is off by default; when on, it shows a delta against a previous period, a team baseline, or a static target, with configurable trend color and delta form.

  • Clicking the tile (when the hyperlink is enabled) opens the approvals list with the tile's filters, in the viewer's context.

  • Aggregation is server-side on the entitled set and respects the visibility model.

Notes

The count-only tile works standalone; measures beyond count and the comparison bases are optional extensions. Add "KPI stat tile" to the supported gadget types.