Yesterday, a customer reached out with a reporting challenge.
They track multiple security KPIs and wanted to see how several metrics change over time on a single chart.
Sounds simple — but monday.com dashboards don’t support this scenario when multiple KPIs are stored in one column.
The challenge
The board contains a column KPI Name with multiple metrics.
The goal was to visualize trends over time for three selected KPIs on one chart.
In monday charts this isn’t possible:
- each chart can display only one KPI at a time
- the only workaround is duplicating charts and applying widget filters
- result → 3 identical widgets instead of one clear visualization
The workaround using Smart Spreadsheet
We solved it using Smart Spreadsheet and a pivot-based dataset.
Step 1 — Group data with Pivot Table
- add a Pivot Table
- set KPI Name as rows
- set time period as columns
- use Value as the metric
- hide totals (in the screenshot below)
Step 2 — Filter only KPIs you want to visualize
- open Pivot settings
- filter KPI Name values
- keep only the needed metrics
- remove unnecessary fields
Step 3 — Build the chart
- select the pivot range
- insert a chart
- enable Transpose (switch rows/columns) → this converts KPIs into separate series
Now the chart shows multiple KPI trends on a single timeline. Use the widget to show the chart in the dashboard.
You can try this setup by installing Smart Spreadsheet in your monday.com account and experimenting with your own KPIs.