Bulk Documentation
Product referenceInsights and visual managementDashboards

Review the KPI Table

Open the KPI Table dashboard to see every assigned KPI as a row, with days, weeks, or months across the top.

Last updated

The KPI Table is a full-screen sheet of the KPIs assigned to the site you have selected. Each row is one KPI. Columns across the top are the days of a month, or the weeks or months of a year, so you can scroll through actuals and compare series side by side, for example daily output against its target.

Use it when the lab or the plant wants a single table of every KPI, not a one-KPI chart or a teamboard widget. Frozen columns hold Category, KPI, Unit, Target, MTD, and Average. Period cells show the actual value and tint green or red when a target exists.

October KPI Table with 14 complete KPI rows, frozen summary columns and actual green and red results on October 1 and 2.
All 14 KPIs, their targets and summaries, and the first week of October. Recorded actuals show real pass and fail colours; unrecorded dates stay blank.

Before you start

  • Permission to view KPIs. The dashboard is gated by View KPIs (kpi.view). Without it, the page explains that permission is required.
  • KPIs assigned to the site. The same assignment rule as Settings, KPI, Targets: a KPI appears when this site is in its allowed list, or when its legacy site matches. If none are assigned, the page shows "No KPIs assigned".
  • Targets and actuals. Cells stay empty and un-tinted until an actual is recorded. Pass and fail colour only appear when both an actual and a target exist for that period.

This board is read-only

The table does not edit targets or actuals. Set daily targets in Settings, KPI, Targets. Record actuals from the usual KPI entry paths.

Open the dashboard

  1. Open the Dashboards area from Home. The picker lists every built-in board.
  2. Find the KPI Table card (code DASH-KPI-T). Double-click it, or select it and choose View DASH-KPI-T.
  3. The board opens full-width with no sidebar. Use Back to dashboards to return to the picker.

The grain, year, and month live in the page address, so a view you build is shareable.

Set the grain and period

Page tabs switch the roll-up:

  • Day shows one column per calendar day of the selected month. Use the month and year controls to move around.
  • Week shows one column per site week of the selected year.
  • Month shows one column per month of the selected year.

The site calendar, not the browser timezone, decides "today" and the week start.

Filter Category, KPI, or Unit from the column headers when you only want some rows. Those filters search every assigned KPI, then the board shows the first 80 matches.

Read the sheet

Frozen columns stay in view while you scroll days:

  • Category and KPI name the row. Category uses the colour from Settings.
  • Unit is the display symbol.
  • Target is the planned value for the visible window, rolled up with that KPI's own method (sum, average, min, or max).
  • MTD is the actual through today on the site calendar (or through the end of a past window). A future window leaves it blank.
  • Average is the mean of period cells that have an actual.

Period cells show the actual for that day, week, or month. Green means the actual met the target. Red means it missed. No colour means there is no actual, no target, or both are missing. If a KPI cannot load its actuals, the row shows an error under the name and leaves those cells empty.

Weekend days and today use a light header tint on the Day grain so you can keep your place while scrolling.

Gotham Applied Sciences example

A shift lead at Gotham Applied Sciences opens KPI Table on Day for October. Daily Output shows 184 in red on October 1 and 216 in green on October 2. Production Cost per Unit shows £13.20 in red and £12.10 in green on the same days. The lead compares those rows with the frozen target, MTD and average, then switches to Week to review the longer trend and shares the page link with the shift huddle.