Unique records where Type Of Shipment = Y
KPI overview.
Explore an independent synthetic demo or analyze your workbook privately in this browser.
Demo mode uses generated synthetic data immediately; workbook selection is available in Local Analysis.
Refine the view
Separate source columns stay separate; values are not merged across similarly named fields.
Arithmetic mean of eligible Type Y weighted shipment scores.
Eligible denominator: 120Eligible Type Y shipments that pass all seven KPIs.
Eligible denominator: 120Type Y records with all seven valid binary KPI values
Operational shipment denominator: 128KPI attainment
KPI Performance Issues
Reasons recorded for failed KPI checks.
Only valid KPI = 0 with a meaningful recorded reason is included. These are issue occurrences, not all failed checks or Data Quality findings.
Search and KPI selection affect this table only. Reports use the Global Filters.
- Total KPI Performance Issues
- 0
- Affected Shipments
- 0
- Transport Model
- 0
- OTD
- 0
- Quote
- 0
- POD
- 0
- Safety
- 0
- HCPOD INV
- 0
- DefOA
- 0
| No recorded KPI performance issues match the current filters. | |||
KPI performance trend
Use Left and Right arrows for periods, Up and Down arrows for KPIs, Home and End for the first and last period. Tab leaves the chart.
| Period | KPI | Pass rate (%) | Passed shipments | Eligible shipments | Low sample size |
|---|---|---|---|---|---|
| Jan 26 | Transport Model | 100.0% | 22 | 22 | No |
| Jan 26 | OTD | 95.5% | 21 | 22 | No |
| Jan 26 | Quote | 90.9% | 20 | 22 | No |
| Jan 26 | POD | 86.4% | 19 | 22 | No |
| Jan 26 | Safety | 100.0% | 22 | 22 | No |
| Jan 26 | HCPOD INV | 86.4% | 19 | 22 | No |
| Jan 26 | DefOA | 95.5% | 21 | 22 | No |
| Feb 26 | Transport Model | 96.3% | 26 | 27 | No |
| Feb 26 | OTD | 88.9% | 24 | 27 | No |
| Feb 26 | Quote | 96.3% | 26 | 27 | No |
| Feb 26 | POD | 88.9% | 24 | 27 | No |
| Feb 26 | Safety | 100.0% | 27 | 27 | No |
| Feb 26 | HCPOD INV | 92.6% | 25 | 27 | No |
| Feb 26 | DefOA | 96.3% | 26 | 27 | No |
| Mar 26 | Transport Model | 96.4% | 27 | 28 | No |
| Mar 26 | OTD | 89.3% | 25 | 28 | No |
| Mar 26 | Quote | 96.4% | 27 | 28 | No |
| Mar 26 | POD | 92.9% | 26 | 28 | No |
| Mar 26 | Safety | 96.4% | 27 | 28 | No |
| Mar 26 | HCPOD INV | 92.9% | 26 | 28 | No |
| Mar 26 | DefOA | 89.3% | 25 | 28 | No |
| Apr 26 | Transport Model | 100.0% | 28 | 28 | No |
| Apr 26 | OTD | 92.9% | 26 | 28 | No |
| Apr 26 | Quote | 92.9% | 26 | 28 | No |
| Apr 26 | POD | 89.3% | 25 | 28 | No |
| Apr 26 | Safety | 100.0% | 28 | 28 | No |
| Apr 26 | HCPOD INV | 89.3% | 25 | 28 | No |
| Apr 26 | DefOA | 92.9% | 26 | 28 | No |
| May 26 | Transport Model | 100.0% | 7 | 7 | No |
| May 26 | OTD | 100.0% | 7 | 7 | No |
| May 26 | Quote | 100.0% | 7 | 7 | No |
| May 26 | POD | 85.7% | 6 | 7 | No |
| May 26 | Safety | 100.0% | 7 | 7 | No |
| May 26 | HCPOD INV | 85.7% | 6 | 7 | No |
| May 26 | DefOA | 100.0% | 7 | 7 | No |
Rates use eligible Type Y shipments per period. Periods with no eligible shipments display as N/A and break the lines. 8 eligible shipment(s) omitted because Actual Delivery Date is missing or invalid; no period is inferred.
KPI comparison
KPI Glossary
Owner-confirmed definitions are preserved in their official English wording. These names do not add calculation or eligibility rules.
| KPI | Official definition | Weight |
|---|---|---|
| Transport Model | Data of Details Transport Model | 5% |
| OTD | On Time Delivery | 35% |
| Quote | Final Quotation Submission | 10% |
| POD | Proof of Delivery Submission | 15% |
| Safety | Health and Safety Delivery | 10% |
| HCPOD INV | Invoice & Hardcopy POD Submission | 20% |
| DefOA | Defect On Arrival | 5% |
| KPI | Pass rate (%) | Weight (%) | Passed shipments | Eligible shipments |
|---|---|---|---|---|
| Transport Model | 98.3% | 5% | 118 | 120 |
| OTD | 92.5% | 35% | 111 | 120 |
| Quote | 94.2% | 10% | 113 | 120 |
| POD | 89.2% | 15% | 107 | 120 |
| Safety | 99.2% | 10% | 119 | 120 |
| HCPOD INV | 90.8% | 20% | 109 | 120 |
| DefOA | 93.3% | 5% | 112 | 120 |
Official KPI weights are shown beside each KPI. Pass rates use the same filtered, eligible Type Y population as the summary metrics.
Interactive rankings
| Rank | Demo Transporter | Average Weighted KPI Score | Full compliance | Eligible shipments |
|---|---|---|---|---|
| 1 | Demo Carrier 2 | 94.17% | 73.33% | 30 |
| 2 | Demo Carrier 1 | 93.67% | 66.67% | 30 |
| 3 | Demo Carrier 3 | 92.00% | 56.67% | 30 |
| 4 | Demo Carrier 4 | 91.50% | 60.00% | 30 |
Average Weighted KPI Score; Ranking rates use the applied weighting. Full KPI Compliance Rate tie-break remains shipment-based; ties after compliance use eligible shipment count, then group name. “Low sample” means fewer than 5 eligible shipments.
Shipment Overview
Completed Type Y shipments after global and category filters. Explorer includes all statuses.
Shipment Performance Insights
Shipment volume and category distribution only; not delivery quality, on-time delivery, or KPI compliance. Highest, lowest, and latest use included dated records; periods may be ongoing, future-dated, or filter-clipped. Period Comparison uses elapsed, fully filter-covered periods.
- Highest Shipment Period
- Mar 2628 shipments+1 other periods tied
- Lowest Shipment Period
- May 2615 shipments
- Average Monthly Shipment Growth
- N/AInsufficient valid monthly comparisons.Valid monthly comparisons: 0Average of valid monthly changes—not first-to-last growth.
Calculation Details
Arithmetic average of valid monthly percentage changes.
Always calculated monthly, regardless of the selected chart aggregation.
Average month-over-month shipment change across the selected period, based on available records.
Excluded zero-baseline comparisons: 0
Current, future, and date-filter-clipped months are excluded. Calendar completion does not prove reporting completeness.
- Reguler Contribution
- 50.0%60 / 120 Completed Type Y shipmentsDenominator: completed Type Y shipments in the current category selection, including unclassified and undated records.
- SIHREN Contribution
- 50.0%60 / 120 Completed Type Y shipmentsDenominator: completed Type Y shipments in the current category selection, including unclassified and undated records.
- Latest Period Shipment Volume
- May 26Total Shipment: 15Reguler: 7 · SIHREN: 8Reporting completeness unknown. Latest refers to the included timeline, not necessarily the current calendar period.
Period insights use matching dated shipments. Missing or invalid dates are not zero-count periods; timeline coverage does not prove reporting completeness.
Shipment Period Comparison
Compare shipment volume across consecutive calendar periods, using available records.
Comparison availability is checked after the local calendar date is ready.
Based on available records; reporting completeness is unknown.
Calculation Details
Absolute change = current count - previous count. Percentage change = (current - previous) / previous, displayed as a percentage.
The target is compared only with its immediately preceding calendar month, quarter, or year. Current, future, and date-filter-clipped periods are excluded.
If the previous period has zero shipments, percentage change is unavailable.
A zero baseline produces N/A for percentage change; absolute change remains available. Zero counts mean no matching dated records, not verified operational inactivity.
Missing or invalid Actual Delivery Dates cannot be assigned to a period. Date filters may already exclude these records. No records outside the filters are retrieved.
Total = Reguler + SIHREN + Unclassified. Category absolute changes reconcile to total change; category percentages are not added.
Total Shipment Trend
Total shipment count per period.
- Total Shipment
Use Left and Right arrows to explore periods. Home and End select the first and last period. Tab leaves the chart.
View shipment trend data
| Period | Total Shipment (shipments) |
|---|---|
| Jan 26 | 22 |
| Feb 26 | 27 |
| Mar 26 | 28 |
| Apr 26 | 28 |
| May 26 | 15 |
Reguler vs SIHREN Shipment Trend
Comparison of SIHREN and Reguler shipment counts.
- Reguler
- SIHREN
Use Left and Right arrows to explore periods. Home and End select the first and last period. Tab leaves the chart.
View shipment trend data
| Period | Reguler (shipments) | SIHREN (shipments) |
|---|---|---|
| Jan 26 | 12 | 10 |
| Feb 26 | 13 | 14 |
| Mar 26 | 13 | 15 |
| Apr 26 | 15 | 13 |
| May 26 | 7 | 8 |
Shipment Explorer
Showing 1–10 of 128 filtered shipments
Scroll horizontally to view all shipment fields.
| N/A | N/A | Jawa | Demo Equipment 1 | N/A | 100.00% | Eligible | |
| Demo Carrier 2 | Demo Destination 2 | Sumatra | Demo Equipment 2 | Jan 09, 2026 | 100.00% | Eligible | |
| Demo Carrier 3 | Demo Destination 3 | Kalimantan | Demo Equipment 3 | Jan 11, 2026 | 90.00% | Eligible | |
| Demo Carrier 4 | Demo Destination 4 | Maluku | Demo Equipment 1 | Jan 13, 2026 | 65.00% | Eligible | |
| Demo Carrier 1 | Demo Destination 5 | Jawa | Demo Equipment 2 | Jan 11, 2026 | 100.00% | Eligible | |
| Demo Carrier 2 | Demo Destination 6 | Kalimantan | Demo Equipment 3 | Jan 13, 2026 | 100.00% | Eligible | |
| Demo Carrier 3 | Demo Destination 7 | Bali & Nusa Tenggara | Demo Equipment 1 | Jan 15, 2026 | 65.00% | Eligible | |
| Demo Carrier 4 | Demo Destination 8 | Jawa | Demo Equipment 2 | Jan 17, 2026 | 95.00% | Eligible | |
| Demo Carrier 1 | Demo Destination 9 | Sumatra | Demo Equipment 3 | Jan 15, 2026 | 100.00% | Eligible | |
| Demo Carrier 2 | Demo Destination 10 | Sulawesi | Demo Equipment 1 | Jan 17, 2026 | 100.00% | Eligible |
KPI-ineligible Type Y rows remain visible in operational counts; their score and benchmark comparison are unavailable.
Geographic Intelligence
Source-backed geography is not externally verified. Shared coordinates do not verify hospital identity. Counts use exact source spellings; cities require a province.
No source-backed Province values are available. Region is not used as a substitute.
Shipment category mix
- Reguler64
- SIHREN64
- Unclassified0
Jobs needing review
Each job is counted once in the review total. Reason counts can overlap; unavailable Item Name is also flagged.
- City / Regency — not provided128
- Coordinates — missing12
- Item Name — not provided128
- Province — not provided128
Province breakdown
| Province: | Total filtered jobs | Mapped jobs | Unmapped jobs |
|---|---|---|---|
| Province unavailable / needs review | 128 | 116 | 12 |
Financial Analytics
Demo Data · Selected financial scope: Type Y
Recorded Sales represents the agreed sales amount in AO - Total Sell, not recognized accounting revenue, collected cash, paid invoices or cash flow. Done does not establish revenue recognition.
Financial demo records are independently synthetic and contain no customer workbook data.
Financial Filters
Financial filters affect this tab only. Operational Global Filters do not apply here.
Undated records remain in unfiltered totals. Active date filters and dated visualizations exclude them.
Changing shipment scope clears dimension selections; category and date selections remain.
Financial Overview
Filtered financial records: 24 · Selected financial scope: Type Y
Total Recorded Sales
IDR 145,390,670Total Recorded Cost
IDR 117,563,000Total Recorded Profit
IDR 27,827,670Overall Profit Margin
19.14%Eligible Financial Records
22Financial Exceptions
2Loss-Making Records
3Undated Records
4Sales, cost, profit and margin use the same eligible financial cohort. Exceptions remain in record counts and the detail table.
Shipment-status financial breakdown
| Shipment Status | Records | Eligible Financial Records | Recorded Sales | Recorded Cost | Recorded Profit |
|---|---|---|---|---|---|
| Done | 6 | 6 | IDR 41,703,480 | IDR 32,292,000 | IDR 9,411,480 |
| Cancel | 6 | 6 | IDR 31,014,170 | IDR 28,973,000 | IDR 2,041,170 |
| Blank | 6 | 5 | IDR 33,963,420 | IDR 26,298,000 | IDR 7,665,420 |
| Other | 6 | 5 | IDR 38,709,600 | IDR 30,000,000 | IDR 8,709,600 |
Recorded Sales and Recorded Cost by component
Component pairs are analytical comparisons, not confirmed identical commercial services. Differences are not accounting profit.
Monetary bars share one absolute IDR scale; composition bars show cost percentages. Negative amounts retain their minus sign. Incomplete coverage is not confirmed zero.
| Component | Recorded Sales | Recorded Cost | Component difference | Cost composition | Missing cost / sales |
|---|---|---|---|---|---|
| Freight | IDR 14,471,150 | IDR 12,063,000 | IDR 2,408,150 | 10.26% | 0 / 0 of 22 |
| Move In | IDR 14,920,960 | IDR 12,349,000 | IDR 2,571,960 | 10.5% | 0 / 0 of 22 |
| Plywood (15 mm) | IDR 15,375,710 | IDR 12,635,000 | IDR 2,740,710 | 10.75% | 0 / 0 of 22 |
| Rubber | IDR 15,835,400 | IDR 12,921,000 | IDR 2,914,400 | 10.99% | 0 / 0 of 22 |
| MOB / DEMOB | IDR 16,300,030 | IDR 13,207,000 | IDR 3,093,030 | 11.23% | 0 / 0 of 22 |
| Additional charges | IDR 16,769,600 | IDR 13,493,000 | IDR 3,276,600 | 11.48% | 0 / 0 of 22 |
| Survey | IDR 17,244,110 | IDR 13,779,000 | IDR 3,465,110 | 11.72% | 0 / 0 of 22 |
| Handpallet rental | IDR 17,723,560 | IDR 14,065,000 | IDR 3,658,560 | 11.96% | 0 / 0 of 22 |
| Crane | IDR 16,750,150 | IDR 13,051,000 | IDR 3,699,150 | 11.1% | 2 / 2 of 22 |
Financial Export
Financial data is confidential. Review the export scope before sharing.
Summary CSV and Confidential Summary retain conservative suppression. Authorized Management Report permits explicitly confirmed richer aggregates; neither mode is anonymous.
Exports use current financial scope, filters, trend granularity and ranking selections. Financial table search and pagination do not limit export records.
Financial PDFs never include shipment-level details. Detailed CSV requires consent for each export.
Financial Performance Trends
Recorded Sales is the agreed amount in AO - Total Sell, not recognized revenue, collected cash, paid invoices or cash flow.
Undated Records: 4 · Eligible undated records: 4. Undated records remain in unfiltered headlines but cannot enter dated trends. Date filters exclude them.
Calendar completion does not prove reporting completeness. Empty interior periods mean no observed eligible activity, not confirmed zero business activity.
Recorded Sales, Recorded Cost and Recorded Profit
IDR chart; exact values are available in the trend data table. 11 Periods
Scroll horizontally to view the full chart.
Overall Profit Margin
Percentage chart; unavailable margins are gaps, not zero values.
Scroll horizontally to view the full chart.
Financial trend data table
| Period | Period coverage | Eligible Financial Records | Financial Exceptions | Recorded Sales | Recorded Cost | Recorded Profit | Overall Profit Margin | Loss-Making Records |
|---|---|---|---|---|---|---|---|---|
| Feb 25 | Calendar status pending | 3 | 0 | IDR 15,371,660 | IDR 13,286,000 | IDR 2,085,660 | 13.57% | 1 |
| Mar 25 | Calendar status pending | 2 | 0 | IDR 12,322,200 | IDR 9,540,000 | IDR 2,782,200 | 22.58% | 0 |
| Apr 25 | Calendar status pending · No observed records | 0 | 0 | IDR 0 | IDR 0 | IDR 0 | N/A | 0 |
| May 25 | Calendar status pending | 2 | 0 | IDR 10,743,240 | IDR 8,316,000 | IDR 2,427,240 | 22.59% | 0 |
| Jun 25 | Calendar status pending | 3 | 0 | IDR 15,642,510 | IDR 15,687,000 | -IDR 44,490 | -0.28% | 2 |
| Jul 25 | Calendar status pending · No observed records | 0 | 0 | IDR 0 | IDR 0 | IDR 0 | N/A | 0 |
| Aug 25 | Calendar status pending | 2 | 0 | IDR 16,664,340 | IDR 12,906,000 | IDR 3,758,340 | 22.55% | 0 |
| Sep 25 | Calendar status pending | 3 | 0 | IDR 22,035,960 | IDR 17,064,000 | IDR 4,971,960 | 22.56% | 0 |
| Oct 25 | Calendar status pending · No observed records | 0 | 0 | IDR 0 | IDR 0 | IDR 0 | N/A | 0 |
| Nov 25 | Calendar status pending | 2 | 1 | IDR 15,480,120 | IDR 11,988,000 | IDR 3,492,120 | 22.56% | 0 |
| Dec 25 | Calendar status pending | 1 | 1 | IDR 6,959,880 | IDR 5,412,000 | IDR 1,547,880 | 22.24% | 0 |
Financial Period Comparison · MoM
Nov 25 → Dec 25
Calendar status pending
Previous: Calendar status pending
Comparison caution: partial periods, missing prior periods or periods without eligible records are not directly comparable.
| Metric | Previous | Current | Absolute change | Percentage change |
|---|---|---|---|---|
| Recorded Sales | IDR 15,480,120 | IDR 6,959,880 | -IDR 8,520,240 | -55.04% |
| Recorded Cost | IDR 11,988,000 | IDR 5,412,000 | -IDR 6,576,000 | -54.85% |
| Recorded Profit | IDR 3,492,120 | IDR 1,547,880 | -IDR 1,944,240 | -55.68% |
| Overall Profit Margin | 22.56% | 22.24% | -0.32 percentage points | Not a percentage growth metric |
Profitability Rankings
Best sorts the selected metric descending; Lowest sorts ascending. Higher cost or loss counts are not recommendations. Unavailable metrics appear last.
| Group | Ranking value | Eligible Financial Records | Recorded Sales | Recorded Cost | Recorded Profit | Overall Profit Margin | Loss-Making Records | Financial Exceptions |
|---|---|---|---|---|---|---|---|---|
| Demo Financial Region 2 | IDR 14,856,150 | 11 | IDR 71,963,150 | IDR 57,107,000 | IDR 14,856,150 | 20.64% | 1 | 1 |
| Demo Financial Region 3 | IDR 12,971,520 | 11 | IDR 73,427,520 | IDR 60,456,000 | IDR 12,971,520 | 17.67% | 2 | 1 |
Automated Financial Insights
Deterministic observations from the active financial scope and filters. No external AI service is used.
Selected financial scope: Type Y · Region / Province
Observed filtered records only. Calendar completion does not prove reporting completeness.
Largest recorded cost component
Handpallet rental
- Recorded Cost
- IDR 14,065,000
- Cost composition
- 11.96%
Largest observed component cost in the eligible cohort; no cause of profitability is inferred.
Highest recorded profit period
Sep 25
- Recorded Profit
- IDR 4,971,960
- Eligible Financial Records
- 3
Among periods with eligible dated records; ties use the earliest period. Partial periods may be included.
Lowest recorded profit period
Jun 25
- Recorded Profit
- -IDR 44,490
- Eligible Financial Records
- 3
Among periods with eligible dated records; ties use the earliest period. Partial periods may be included.
Loss-making records in scope
- Loss-Making Records
- 3
Eligible records with negative Recorded Profit. No accounting or misconduct conclusion is implied.
Observed losses or financial exceptions
Group with most loss-making records
Demo Financial Region 3
- Loss-Making Records
- 2
- Eligible Financial Records
- 11
Largest eligible loss-making record count within the selected grouping; this does not rank loss magnitude.
Observed losses or financial exceptions
Lowest group margin with sufficient sample
Demo Financial Region 3
- Overall Profit Margin
- 17.67%
- Eligible Financial Records
- 11
Aggregate profit divided by positive aggregate sales; at least five eligible records are required.
More financial insights
Financial exception coverage
- Financial Exceptions
- 2
- Filtered financial records
- 24
Exceptions remain in record counts and are excluded from reconciled monetary totals.
Observed losses or financial exceptions
Undated financial coverage
- Undated Records
- 4
- Eligible undated records
- 4
Undated records remain in unfiltered headlines but cannot enter dated trends. Date filters exclude them.
Status-specific financial amounts
Cancel
- Records
- 6
- Recorded Sales
- IDR 31,014,170
All-status financial collection; amounts are recorded values, not proof of recognized revenue or cash collection.
Status-specific financial amounts
Blank
- Records
- 6
- Recorded Sales
- IDR 33,963,420
All-status financial collection; amounts are recorded values, not proof of recognized revenue or cash collection.
Status-specific financial amounts
Other
- Records
- 6
- Recorded Sales
- IDR 38,709,600
All-status financial collection; amounts are recorded values, not proof of recognized revenue or cash collection.
Financial Records
Matching financial records: 24 · Page 1 of 3
| Shipment Type | Shipment Status | Region / Province | Financial Validation Status | ||||||
|---|---|---|---|---|---|---|---|---|---|
| SYNTHETIC-FIN-002 | Y | Cancel | 2025-02-15 | Demo Financial Region 2 / Demo Financial Province 2 | IDR 3,595,290 | IDR 2,781,000 | IDR 814,290 | 22.65% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-003 | Y | Blank | 2025-03-15 | Demo Financial Region 3 / Demo Financial Province 3 | IDR 3,792,660 | IDR 2,934,000 | IDR 858,660 | 22.64% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-005 | Y | Done | 2025-05-15 | Demo Financial Region 2 / Demo Financial Province 5 | IDR 4,187,400 | IDR 3,240,000 | IDR 947,400 | 22.63% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-006 | Y | Cancel | 2025-06-15 | Demo Financial Region 3 / Demo Financial Province 6 | IDR 2,884,050 | IDR 3,393,000 | -IDR 508,950Loss-making record | -17.65% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-008 | Y | Other | Undated | Demo Financial Region 2 / Demo Financial Province 2 | IDR 4,779,510 | IDR 3,699,000 | IDR 1,080,510 | 22.61% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-009 | Y | Done | 2025-09-15 | Demo Financial Region 3 / Demo Financial Province 3 | IDR 4,976,880 | IDR 3,852,000 | IDR 1,124,880 | 22.6% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-011 | Y | Blank | 2025-11-15 | Demo Financial Region 2 / Demo Financial Province 5 | IDR 5,371,620 | IDR 4,158,000 | IDR 1,213,620 | 22.59% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-012 | Y | Other | 2025-12-15 | Demo Financial Region 3 / Demo Financial Province 6 | IDR 5,568,990 | Missing | IDR 1,257,990 | 22.59% | Financial exceptionValidation details
|
| SYNTHETIC-FIN-014 | Y | Cancel | 2025-02-15 | Demo Financial Region 2 / Demo Financial Province 2 | IDR 3,444,200 | IDR 4,052,000 | -IDR 607,800Loss-making record | -17.65% | Financially eligibleValidation details
|
| SYNTHETIC-FIN-015 | Y | Blank | Undated | Demo Financial Region 3 / Demo Financial Province 3 | IDR 6,161,100 | IDR 4,770,000 | IDR 1,391,100 | 22.58% | Financially eligibleValidation details
|
Data quality & validation
Quality checks are independent of KPI eligibility except for missing or invalid official KPI values.
Nonblank source rows and Type Y jobs are dataset-level processing information and do not change with Global Filters.
All validation metrics, charts and issue details below use the current Global Filters. One shipment can have multiple issues.
Issue distribution
Select a group to drill into issues.
Issue trend
Issues with missing or invalid Actual Delivery Date are excluded from dated periods: 9.
VALIDATION METHODMethodology & rulebookExpand / collapse
All checks run locally in this browser against all Type Of Shipment = Y jobs with identical rows preserved. No source workbook is changed, uploaded, or persisted.
- KPI: exactly seven official fields must each equal 0 or 1 (for example, 1 passes and 0 fails). Weighted score remains the official passing-weight sum divided by 100. Only invalid or missing KPI values make a shipment KPI-ineligible.
- Data Quality Rate: (Type Y shipments − unique shipments with one or more issues) ÷ Type Y shipments.
- KPI Eligibility Rate: eligible Type Y shipments ÷ all Type Y jobs.
- Affected Shipments: Type Y jobs with one or more detected issues. Total Issues counts individual findings.
- Duplicates: Every nonblank Type Y row is preserved, including identical jobs. Blank rows are excluded. Duplicate exclusions apply only to Financial Analytics and never reduce operational denominators.
- Dates and chronology: dates must be real calendar dates (for example, February 30 is invalid); valid pickup cannot follow valid actual delivery. Invalid dates are not assigned to a trend period.
- Tonnage / CBM: when a recognized source column exists, each value must be present and finite, numeric, and greater than zero; missing measurements are reported, never estimated.
- Coordinates: mapped only for unambiguous valid latitude/longitude ranges; missing, malformed, ambiguous, and out-of-range values are distinct issues.
- Region / province: consistency means a province maps to one region label within this workbook; it is not checked against an external geographic authority.
- Status: delivered/completed requires an actual delivery date; pending, in-transit, and cancelled records must not have one.
- Quality issue ≠ KPI exclusion: metadata, date, location, and status issues do not affect KPI eligibility.
- Origin completeness (source column unavailable)
- Region completeness (source column unavailable)
- Province completeness (source column unavailable)
- Tonnage validation (no recognized tonnage column)
- CBM validation (no recognized CBM/volume column)
- Region/province consistency (requires both columns)
Issue explorer
Showing 1–25 of 28 issues · 28 within current Global Filters
| Reason | |||||
|---|---|---|---|---|---|
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | Missing operational metadata | Lead Time | Actual Delivery Date | Actual Delivery Date is blank although this column exists in the workbook. | |
| Warning | KPI value | KPI | KPI OTD | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI Quote | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI POD | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI Safety | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI HCPOD INV | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI DefOA | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI Transport Model | KPI cell is missing or is not the binary value 0 or 1. | |
| Warning | KPI value | KPI | KPI OTD | KPI cell is missing or is not the binary value 0 or 1. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. | |
| Info | Invalid LongLat coordinates | Map | Latitude | Coordinate cell is blank. |