Thermometer chart

What problem are you trying to solve?

Preset currently lacks a clear and intuitive way to display multiple percentage-based KPIs (e.g. OTD %, SLA %, Success %) side by side with meaningful, value-based colour encoding.

Percentage metrics are most useful when users can instantly understand status (good / at risk / failing). For example:

• 100% → green (on target)

• 50% → amber (warning)

• 10% → red (off target)

How are you solving it today?

• Using standard bar charts and manually calculating percentages in SQL.

• Colour encoding cannot be applied dynamically based on metric thresholds.

• Workarounds (custom SQL, CASE statements, separate charts) are fragile, hard to maintain, and don’t scale well across dashboards.

• The result is reduced readability and slower interpretation for business users.

What is your recommended solution?

Introduce a dedicated “KPI Bar / Threshold Bar” chart type (or extend existing bar charts) with the following capabilities:

• Display multiple percentage metrics side by side in a single visual.

• Support value-based colour rules (e.g. conditional formatting / thresholds).

• User-configurable thresholds (e.g. ≥95% green, 80–94% amber, <80% red).

• Optional target/benchmark indicators.

• Works directly with metric outputs (no SQL workarounds required).