KPI Trend Recalculation
Now Live in Presto
Flexible Performance Insight At Your Fingertips
Recalculate red-amber-green KPI trends in seconds by average, median, and selected reporting period.
Example: Recalculate the KPI traffic-light dashboard using average or median trends across a selected period.
The new KPI Trend Recalculation feature gives Team Leads, Managers, and KPI Owners a faster way to understand what their dashboard is really telling them.
Instead of relying only on the latest KPI result, users can now recalculate the red-amber-green traffic-light view using a selected number of results, days, weeks, months, quarters, or years.
The goal is simple: help leaders get closer to their KPIs, spot emerging trouble areas earlier, and make better decisions during daily, weekly, and monthly performance reviews.
-
Recalculate KPI traffic lights instantly.
-
Switch between average and median calculations.
-
Review performance trends across flexible reporting windows.
TrendLens Control: Use one simple dropdown to recalculate the dashboard and reveal whether current performance is improving, drifting, or quietly moving toward risk.
On-the-fly recalculation
Change the calculation window during a meeting without rebuilding reports or exporting data.
Average or median
Use averages for normal trend reviews or median calculations when outliers may distort the picture.
Find hidden trouble
Reveal KPIs that may look acceptable today but are trending toward amber or red over time.
Traditional KPI review vs Presto PDCA
Traditional KPI review
- Traffic lights are fixed to one view
- Trend checks require manual analysis
- Outliers can distort the story
- Managers react after performance has already slipped
Presto PDCA approach
- Flexible red-amber-green recalculation
- Average and median trend options
- Results-based and time-based review periods
- Faster identification of lurking trouble areas
How to Use It
1) Open the KPI Traffic-Light Dashboard
Start from the KPI dashboard where the red-amber-green status gives Team Leads a quick view of performance across their metrics.
This is the ideal place to begin a daily huddle, weekly performance review, or monthly operating meeting.
2) Select the Trend Calculation Period
Use the dropdown to choose whether the dashboard should recalculate status based on the last selected number of results, days, weeks, months, quarters, or years.
Example: Choose the reporting window that best matches the management question being asked.
3) Choose Average or Median
For most operational reviews, average gives a simple, familiar trend calculation. For more advanced users, median can help reduce the influence of unusual spikes, one-off events, or reporting anomalies.
4) Review the Updated Traffic-Light View
Once recalculated, the dashboard gives the Team Lead a fresh view of which KPIs are stable, improving, drifting, or moving toward risk.
This makes the dashboard more useful as a live coaching tool, not just a historical reporting screen.
Recommended Ways to Use It
-
Use last 5 or 10 results during short-interval reviews to test whether a problem is temporary or recurring.
-
Use last 4 weeks to prepare team-level huddles and identify KPIs that need active follow-up.
-
Use quarterly or yearly views to support monthly business reviews and senior management conversations.
What the updated traffic lights can reveal
Green but drifting
A KPI may still look acceptable today, but the recalculated trend can show deterioration before it becomes visible.
Amber and unstable
A KPI may need a focused countermeasure if the trend remains inconsistent across the selected period.
Red with pattern
A KPI may require deeper root cause review if poor performance persists across multiple results or weeks.
Tip: Start by asking Team Leads to compare the latest KPI status against the last 5 results, last 4 weeks, and last quarter. The discussion often reveals whether the issue is a one-off event or a real trend.