Flitch

Inspector

Trace any value to its source, edit values and formulas, restyle any element.

Click any chart, value, or element in the editor to open the inspector. Two tabs: Data and Design.

Data inspector

Every value in every chart, table, and KPI is traceable to the exact source record. Click to edit values, change formulas, or apply conditional formatting.

Hover to trace

  • Chart points: source record id, columns involved, filters applied. Contributing chart elements highlight in a contrasting overlay.
  • KPIs: aggregation type (sum, average, count, distinct), column, filter group.
  • Table cells: source row id and column name.

When a number looks wrong, hover it. The bug in the data, binding, or assumption surfaces immediately.

Click to edit

  • Override a chart label, axis title, or category name.
  • Change a formula. The formula editor opens with the current calculation and a list of fields, functions, and aggregations.
  • Replace a calculated value with a literal.

Inline edits apply to the dashboard's local copy. They do not write back to the source. Refreshing the data preserves the override unless you remove it.

Conditional formatting

  • Highlight cells above or below a threshold.
  • Gradient scale based on min/max.
  • Categorical palette per value.

Open the inspector on a value, click Add rule, pick the condition. Rules apply to all values in the same column or aggregation.

Calculated fields and formulas

Calculations split between dataset level and dashboard level:

  • Dataset level: every dashboard built on the dataset reuses them.
  • Dashboard level: specific to one view. The inspector handles these.

Common dashboard level formulas:

  • Growth rates between two metrics.
  • Conditional text labels ("On track" / "At risk") based on values.
  • Combining columns into a derived metric local to one chart.

Formulas use SQL like syntax with field references and standard aggregations.

Design inspector

Restyle any element, chart, or the whole dashboard. Edits flow through the same theme system as generation.

Global theme

Palette, corner radius, typography, and density applied across the dashboard. Edit light and dark modes separately.

Per-element styles

Hover any element in the preview to edit it in isolation:

  • Palette: text, fill, stroke. Pick from the theme or a custom hex.
  • Typography: font family, size, weight.
  • Box model: padding, margin, border radius.
  • Text content: titles, axis labels, KPI captions.

Chart-level

  • Change chart type: bar to horizontal bar, line to area, and so on.
  • Chart palette: per-series fills, conditional rules, or theme defaults.

Undo and redo apply across both Data and Design edits.

On this page