The Compliance NTD Trip Samples Report is now available in ETMS. This report replaces the DataPoint NTD reports, if configured for your agency. Use this dashboard to quickly review your service area metrics at a high level for all routes for a selected date range.
Track trends by time, category, and routes; compare this year's data collection to last year’s data and assess if you are below or above the target and adjust targets accordingly. It is very important to keep the coverage and capture rates above 50%. If your system is below 50%, you will need to perform some schedule health analysis and review vehicle APC hardware. This report also identifies missed but scheduled stops. Drill into the missed stops data to begin improving your overall trip samples data collection. *Valid trips used for NTD reporting have fewer than 3 consecutive stops missed.
This dashboard allows you to do the following:
- Assess accepted trips, capture rate, filter capture rate by route
- Identify the coverage rate. Helps you ensure that you capture at least one trip from all service levels and times of day
- Identify the amount of accepted/captured trip samples
- Identify percentage of missed stops and percentage for the onboard over max capacity
- Drill down to more detailed reports
- Filter
The NTD Trip Samples report shows four sub reports: Capture Rate, Coverage Rate, Accepted Trip Samples, NTD Trip Samples by Route, and Missed Stops.
The Capture Rate report provides the capture rate of all sample trips of total trips within the set time frame, compares this percentage to last year, shows the set target and where the rate is respective of the target. The Coverage Rate report provides the same information only looks at unique trips.
The Accepted Trip Samples report shows the number of accepted trips from total trips within the set time frame, compares this percentage to last year, shows the set target and where the rate is respective of the target. Accepted trips are those that have been completed, haven’t missed stops, and when the agency doesn’t have an imbalance between boards and alights.
The NTD Trip Samples by Route report shows information organized by route. This card displays routes, schedules name, trips accepted, capture and coverage rates, onboard over max capacity, board and alight difference, and missed stops (failure) percentage. Clicking on a Missed Stops percentage will lead the user to the Incomplete Stop Segments report showing the list of stop segments, captured and scheduled trips, and their incomplete segments. Clicking on an Onboard Over Max Cap percentage will lead the user to the Farebox and APC Analysis report for that specific route and the date range selected.
Clicking on the plus icon will expand the table and show separate trips that pertained to that route. It shows the date, vehicle, trip, direction, passenger miles, total boardings, and stops detail.
Clicking on the Stops Detail link 
opens the NTD Stops for Trip XXX report showing stop ID, stop, distance, boards, alights, onboard, passenger miles information, and totals for those.
The export to PDF button 
will be grayed out in this very report. Hovering over it will ask the user to select single day to export as a PDF for capacity/handling reasons:
Clicking on the Export as Excel button 
will export the report to Excel.
Back on the NTD Trip Samples report, you can export this report to either PDF or Excel by clicking on the Export as PDF button 
or Export as Excel button at the top right corner.
The Scheduler button 
allows the user to schedule this report to go out in an email to, for example, a management department at any necessary frequency.
Click the global filter icon at the top 
to restrict data to specific Date, Mode of Service, Route, Schedule, and Service Level.
Click the information icon by a panel 
to learn about its metrics and how the system calculates them.
Multi-Vehicle Trip Handling Update
The NTD Trip Sampling methodology has been updated to improve data accuracy when a single trip involves multiple vehicles.
Previously, trips involving more than one vehicle could result in multiple vehicle records being stored for the same trip. With this update, the Data Warehouse (DW) will now record only the vehicle that serviced the majority of stops for a given trip.
New Data Recording Logic
- For each trip involving multiple vehicles, the system calculates the total number of stops completed by each vehicle.
- Only the vehicle with the highest number of completed stops is recorded in the DW FactSegmentActual table.
- All other vehicles associated with the trip are excluded from the final trip sample record.
This change ensures that NTD Trip Samples report accurately reflects operational reality by attributing each trip to the vehicle that provided the majority of service, reducing duplication and improving reporting consistency.
Troubleshooting: How Can I Use this NTD Report?
This report helps to identify issues on routes that are underperforming/ missing scheduled stops. It identifies the total number of valid trip samples to be used for NTD reporting and it highlights any missed stops. Why missed stops? If three or more consecutive stops are missed on a trip, the trip sample is considered invalid and will not be used for NTD reporting needs. Identifying missed pieces of scheduled work can be due to a few areas:
- Schedule data issue
- Training needs
- Vehicle condition
When you identify what the issues are, you can begin addressing them by creating action plans.
Schedule Data Analysis
If it's a schedule data issue, review your BI reports - Schedule Health, Running Times, Low Utilization, Schedule Adherence and Geo Tools: trigger boxes, route traces
Training Needs Analysis
Review BI Schedule Health to identify missed stops, timepoints, trips and drill into the data using the built- in link to access Replay. The Replay tool provides you with a more granular level of details to see what really happened on the road. You can also leverage the Logon/Log Off report and Schedule Adherence.
Vehicle Condition Analysis
Use the Maintenance reports to identify issues, such as J1939 vehicle health alerts, GPS connection, etc. Review the Planning/Scheduling report for Farebox & APCs, focusing on APCs only at the vehicle level - to determine if sensors are working as expected and counting boards and alights.