Lens

KPI Tile

A KPI tile shows one metric as a single big number for the date range, with an optional change against an earlier period. Use it for the headline figures a reader should see first.

KPI tile showing 1,284 conversions, up 12.4% against the previous period value of 1,142.
Illustration with the numbers from the Example below

What it shows

A KPI tile shows one metric, added up over the whole date range, as a single number. It can also show how that number changed against an earlier period, and what share it is of a larger total.

Use it forNot for
Headline totals: sessions, orders, revenue, conversion rateTrends over time. Use a Line or Comparison tile
A quick "up or down against last period" checkBreaking a number down by channel, campaign or device. KPI has no Group By
A filtered slice, such as orders from one channel, as a share of all ordersComparing many segments side by side

Example

A table of daily web traffic has one row per day and channel, with these columns:

ColumnKindExample
datedate2026-10-14
channeldimensionPaid Search
sessionsmetric (sum)812
conversionsmetric (sum)37

The board date picker is set to Oct 1 to Oct 30, 2026. In the tile editor:

SettingValue
TitleConversions
TypeKPI
Data TableDaily web traffic
Metricconversions
Compare ToPrevious Period
SizeSmall

The tile shows:

PartShows
Number1,284 (all conversions from Oct 1 to Oct 30)
ChangeAn up arrow and 12.4%, in green, labeled "vs prev period"
Prior valuePrev: 1,142, with the dates Sep 1 - Sep 30

The change is (1,284 - 1,142) / 1,142 = 12.4%. Previous Period is the 30 days just before the board's range.

Data it needs

  • One metric. Any metric on the table works, including ratio and calculated metrics.
  • A date on each row, so the tile can follow the date range. Every synced Lens table has one.
  • For Show as % of total, a metric that adds up (sum or count). Rates have no share.

Settings

The tile editor has three tabs: Basics, Data and Display.

SettingWhat it doesDefault
TitleThe tile heading. Required, up to 80 charactersEmpty
DescriptionText shown behind an info icon on the tile, up to 500 charactersEmpty
SizeSmall (a quarter of the width), Third, Medium (half) or Large (full width)Medium
Data TableThe table the metric comes from. RequiredNone
MetricThe number to show. RequiredNone
FiltersRows the tile counts, such as channel = Paid Search. Several filters must all match. Applied to the current and comparison periodsNone
Join with Table (optional)Combines a second table on shared dimensions. See the limits below before using itNo join
Date rangeInherit from board, Ignore (all available data), Relative range, or Fixed datesInherit from board
Compare ToNone, Previous Period, Same Day Last Week, Same Day Last Month, Same Day Last Year, or Same Week Last Year (-364d)None
Show as % of totalAdds a line under the number: this tile's value as a share of the same metric without this tile's own filtersOff
Wording after the percentageThe words after the share, for example "of all sessions". Shown when Show as % of total is onof total
Abbreviate large numbersShows 4.3M, 686K or 1.2B instead of the full number. Hover shows the exact valueOff
Thresholds (optional)Under Health monitoring: Alert below, Warn below, Warn above, Alert above. Each box can stay emptyEmpty

Line tiles also offer stopped-moving alerts and automatic anomaly flags. A KPI tile does not, because it loads one total rather than day-by-day values.

How it calculates

  • The number. One total for the whole date range. Sum and count metrics are added up. Ratio and calculated metrics are worked out once over the whole range (for example total conversions divided by total sessions), never as an average of daily rates.
  • The date range. By default the tile follows the board's date picker. A tile with its own range shows a badge with that range on the board.
  • Compare To. The tile fetches the comparison window with the same filters and works out (current - prior) / prior, shown to one decimal place with an up or down arrow.
Compare ToComparison window
Previous PeriodThe same number of days, ending the day before the range starts
Same Day Last WeekThe full calendar week before the week the range ends in, using the property's week start day
Same Day Last MonthThe full calendar month before the month the range ends in
Same Day Last YearThe same dates, one year earlier
Same Week Last Year (-364d)The same dates moved back 364 days, so weekdays line up
  • Color. Green or red follows the metric's direction on the table (higher is better unless the metric says lower is better). A neutral metric stays grey.
  • No comparison. If the prior total is zero or less, the tile shows "No comparison data" and the prior dates, not a percentage.
  • % of total. The tile's value divided by the same metric with the date range and board filters, but without the tile's own filters, to one decimal place. It stays hidden for ratio and calculated metrics, and when the total is zero.
  • Formatting. The metric's format on the table (currency, percent, decimals) is used. Abbreviation only applies to values of 1,000 or more and never to percentages.
  • Health. Thresholds are checked against the number the tile shows. A value under Alert below or over Alert above turns the number red; the warn values turn it amber. A threshold left empty means no limit on that side.

What viewers can do

ActionBoardPublic report
Hover the numberShows the exact value when abbreviatedShows the exact value
Hover the prior valueShows the comparison name, value and datesPrior value and dates are printed under the number
Change the date rangeYes, unless the tile has its own range or the board hides date controlsSame
Pick a board comparisonOverrides Compare To on tiles that follow the board datesSame
Use filter chipsYesYes, unless hidden
Read the descriptionInfo iconInfo icon
Summarize with AIWhen AI features are on for the propertyNo

On the public report, a KPI tile also draws a small trend line of the daily values under the number. The board does not.

Limits and gotchas

  • Compare To is measured from the board's date range, not the tile's own range. A tile pinned to Last month with Previous Period compares against the period before the board's range. Use Inherit from board when you need a comparison, or use a Comparison tile.
  • "Same Day Last Week" and "Same Day Last Month" compare whole calendar periods. With a 30-day range, Same Day Last Week compares 30 days against one week. Use Previous Period or Same Day Last Year for a like-for-like length.
  • Previous Period matches length, not calendar. On "This month" up to Oct 29, the comparison is the 29 days before Oct 1, not all of September.
  • Partial periods look like drops. A range that includes today compares a part day against full days.
  • The public report does not show health colors on KPI tiles, and it does not show the date badge for a tile with its own range. Both appear on the board.
  • Joins are board-only. The public report ignores Join with Table, and while a join is set the board ignores the tile's own filters and date range. For combined metrics, build a joined table instead. See Join Tables.
  • Abbreviation keeps only a $ sign. Other currency symbols are dropped from an abbreviated value, and CA$ becomes $.
  • A KPI tile cannot be broken down. For a number per channel, use a Table or Donut tile.