Copied filters, monthly tables, and delayed exception tracking.
(function () {
// ---------- Data for the 3 sheet tabs (Data / Report / Dashboard) ----------
var workbookSheetViews = {
logistics: {
data: ["Month","Shipments","Early","On Time","Late",
"January","18,420","10,806","3,651","3,963",
"February","19,735","11,614","3,916","4,205",
"March","20,112","11,782","4,006","4,324",
"Total","58,267","34,202","11,573","12,492"],
report: ["Metric","January","February","March","Quarter",
"Early Rate","58.7%","58.8%","58.6%","58.7%",
"On-Time Rate","19.8%","19.8%","19.9%","19.9%",
"Late Rate","21.5%","21.3%","21.5%","21.4%",
"Avg Delivery","3.1 days","3.0 days","3.2 days","3.1 days"],
dashboard: ["KPI","Value","Target","Variance","Status",
"Early Deliveries","58.7%","55.0%","+3.7%","Good",
"On-Time Deliveries","19.9%","25.0%","-5.1%","Watch",
"Late Deliveries","21.4%","20.0%","+1.4%","Risk",
"Avg Delivery Days","3.1","3.0","+0.1","Watch"]
}
};
function renderWorkbookSheet(card, tabName) {
var caseKey = card.dataset.case;
var grid = card.querySelector(".ddd-sheet-grid");
var values = workbookSheetViews[caseKey] && workbookSheetViews[caseKey][tabName];
if (!grid || !values) return;
grid.innerHTML = values.map(function (v) { return "" + v + ""; }).join("");
}
// Tabs: click swaps the grid data — this is the only click behavior left on the card
document.querySelectorAll(".ddd-sheet-tabs button").forEach(function (button) {
button.addEventListener("click", function (event) {
event.preventDefault();
var card = button.closest(".ddd-manual-stage");
if (!card) return;
button.parentElement.querySelectorAll("button").forEach(function (tab) {
tab.classList.toggle("is-active", tab === button);
});
renderWorkbookSheet(card, button.dataset.sheetTab);
});
});
})();
The Solution
We developed an interactive Delivery
Performance Analytics Dashboard that
provides complete visibility into delivery
operations and fulfillment performance.
. Early, On-Time, and Late Delivery
Tracking
. Monthly Delivery Performance Trends
. Team-wise Delivery Performance
. Improved delivery visibility across
operations
. Reduced delivery delays through
proactive monitoring
