Forum Discussion
Busses and capacities challenge
A bus has 5 runs a day (at 8:00, at 8:15, 8:30, 8:45, 9:00, & 10:00 ) Said bus can fit 15 people. A 6th run can fit 20 people. The bus has also 6 pick up stops (say Greenwood, Greenlake, Fremon...
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi kalcey,
>>we know that since there are 2 runs on Greenwood, then it follows that the others stops should have the same number. In your case, Greenlake has a count of 1.
Althrough there are 2 runs on Greenwood, but they are in different dates, why others stops should have the same number?
Best Regards,
Angelia
In your example, you have the following:
1/2/2016 Run1 Greenwood
1/2/2016 Run1 Freemont
We know that the list of stops for the same bus is: Greenwood, Greenlake, Fremont, Seattle, Georgetown, Tacoma.
Consequently, If one bus logs 2 passengers at Greenwood, it follows that the bus passed through all other stops, even if no passengers were marked in the data.