Edilitics | Data to Decisions

KPI Card

Show one headline number, with an optional trend line and a comparison against a previous value. Best for the single most important figure on a dashboard.

A KPI card shows a single headline number, optionally with a small trend line beneath it and a comparison against a previous value. Drop one numeric field into Row and, optionally, one categorical or date field into Column. Use it when one number is the most important thing on the dashboard - not a breakdown across categories, which is a bar or pie chart's job.

Total Revenue

$284,500

12.4% vs last period

When to Use

A KPI card answers "what is the number right now, and is it moving in the right direction" - nothing more, deliberately. It strips away every other dimension a chart could show so the one figure that matters gets full visual weight: total revenue this month, active subscriptions today, average response time this week. The optional trend line and previous-value comparison exist to answer "is this good or bad" without requiring a second chart next to it.

The dimension field is optional, but it powers both the trend line and the automatic comparison. Without a dimension, the KPI card shows a static number with no trend line, and a previous-value comparison only appears if you set a manual Base Value. With a dimension assigned, the most recent value becomes "current," the one before it becomes "previous," and every value across the dimension becomes the trend line.

Switch to a different chart when:

  • You need to show the same measure broken down by category, not as one number - use Horizontal Bar
  • The number needs to be shown against a target range or threshold, not just a trend - use a Gauge Chart
  • You need a full table of values, not a single headline figure - use Text Table
ScenarioDimension (optional)Measure
Total revenue this month, vs. last monthMonthSum of revenue
Active subscriber count, trending over the yearMonthCount of active subscriptions
Current average response time, with daily trendDateAverage response time
Static total: lifetime customers acquiredNoneCount of customers
Conversion rate this week, vs. last weekWeekConversion rate %

Required Inputs

FieldTypeCount
DimensionCategorical or Date0 to 1
MeasureNumericExactly 1

For step-by-step build instructions, see Build Your First Chart.

Formatting Options

The Format tab unlocks after the measure field is assigned.

Style

KPI Title is the small label above the headline number - usually the measure's name, but fully editable.

ControlWhat it does
Show KPI TitleShows or hides the title. When hidden, no automatic fallback title appears either.
Enter KPI TitleTitle text. Maximum 50 characters. Leave empty to fall back to the measure field's name in Title Case.
Font Family / ColorTypeface and text color for the title.
Font size5 to 30.
Bold / ItalicWeight and style.
AlignmentLeft, center, or right within the card.

KPI Value controls the large headline number itself, including independent styling for its prefix, the number, and its suffix.

ControlWhat it does
Show KPI ValueShows or hides the headline number.
PrefixText shown before the value, for example a currency symbol. Maximum 100 characters.
SuffixText shown after the value. Maximum 100 characters. Automatically populated with K, M, or B when Display Unit is set, but you can override it manually.
Prefix / Value / Suffix switcherSelects which of the three segments the styling controls below apply to - each segment keeps its own independent font, size, color, weight, and style.
Number TypeDefault, Scientific, Decimal, Currency, Percentage, or Custom. Applies to the Value segment only.
Display UnitNone, Thousand, Million, or Billion. Scales the number and updates the auto-suffix. Applies to the Value segment only.
Decimal Places0 to 6. Applies to the Value segment only.
Font Family / Color / Font size / Bold / ItalicStyling for whichever segment (Prefix, Value, or Suffix) is currently selected. Default value font size is 36, intentionally larger than the title.
AlignmentLeft, center, or right. This applies to the entire value row at once, not per segment.

KPI Charts controls the small trend line beneath the headline number. This panel does not appear in the Format tab at all if the assigned data doesn't support a trend line - no dimension assigned, or rows missing either the dimension or measure value.

ControlWhat it does
Show KPI ChartShows or hides the trend line without removing the underlying data.
Chart TypeArea (default): line with the space underneath filled. Line: just the trend line, no fill. Bar: each data point as a thin vertical bar. Switching types is purely visual - the same data drives all three.
Primary ColorThe single color used for the trend line, fill, or bars depending on Chart Type.

If your KPI card shows only a static number with no trend line visible, check whether a dimension field is assigned. The trend line - and this entire formatting panel - requires dimension values to plot against.

KPI Trend (labeled "KPI Trend & Base Value" in the panel) controls the up/down indicator, its colors, and the comparison value shown next to the headline number.

ControlWhat it does
Show KPI Trend & Base ValueShows or hides the entire trend indicator and comparison row.
Base ValueManually fixes the "previous" value used for comparison, overriding the automatic second-to-last data point. Setting this clears any manually forced trend direction, so the up/down indicator recalculates from the new comparison.
Font Family / Font size / Bold / ItalicStyling shared by the trend indicator and the comparison value text.
Color (via font/color picker)Sets the color for whichever trend direction is currently active (Up, Down, or Neutral) - the picker targets the live direction, not all three at once.
AlignmentLeft, center, or right for the trend and comparison row.

The up/down/flat direction is always determined by the data - either the computed percentage change between current and previous value, or a trend you force manually. Changing the color picker here recolors whichever direction is currently showing; it does not let a declining number display in the "up" color unless the direction itself is overridden.

Best Practices

Decide whether the dimension field should be assigned before building. A KPI card with no dimension is a clean, static number - good for lifetime totals or figures that have no natural "previous period." A KPI card with a dimension assigned gets a trend line and an automatic period-over-period comparison - good for any recurring metric like monthly revenue or weekly active users. Pick deliberately rather than leaving it unassigned by accident.

Use a manual Base Value when the automatic comparison doesn't match the question. The default previous value is simply the second-to-last data point - if your real comparison should be against the same period last year, or against a target, set Base Value explicitly rather than relying on the automatic adjacent-point comparison.

Keep the title short or let it auto-generate. With a 50-character limit and a large headline number below it, KPI Title works best as a short label. If the measure's field name is already presentation-ready, leaving the title empty and letting it auto-fill from the field name is often cleaner than retyping the same text.

Match Display Unit to the number's actual scale. A revenue KPI in the millions reads better as "$4.2M" than as "$4,200,000" - set Display Unit to Million rather than relying on Decimal Places alone to manage a long number.

Don't force a trend direction unless the underlying data genuinely doesn't support an automatic one. Manually forcing "up" or "down" overrides the computed direction entirely - useful for KPIs without a real previous-period comparison, but easy to forget you've set it and end up with a indicator that no longer matches the actual numbers if the data changes later.

FAQs

Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.

Last updated on

On this page