The DataPoint NTD Trip Samples Report is now available in ETMS, or my Avail 7.4.9+, which opens in a new browser. Use this dashboard to review your service area metrics at a high level, across all routes. Use the filter to focus on individual routes, update the date range, review historical values for comparison, and more. Identify the total number of trip samples and the percent of all trips valid samples. Track trends by time, category, and routes; compare all the data to the last year’s data; 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 dashboard allows you to do the following:
- Assess 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 failed stops or percentage for the onboard over max capacity.
- Drill down to more detailed reports.
The NTD Trip Samples report shows four sub reports: Capture Rate, Coverage Rate, Accepted Trip Samples, and NTD Trip Samples by Route.
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.