User talk:66.183.40.56

From Wikipedia, the free encyclopedia
Jump to: navigation, search

Skytrain[edit]

Where are you getting the ridership numbers for the stations? Secondarywaltz (talk) 19:34, 15 November 2011 (UTC)

I don't know how to reference it. Its obtained from the data from this article. The ridership number is hidden by default, and you'll have to download the application, create a new worksheet to add the 'Station' dimension and 'Boardings 2009' measure.
Detailed step-by-step, with one correction. At the article above, click the download link.
  1. Download the workbook. It's named "Fare Paid - Ross.twbx"
  2. Download the app. It's named "TableauPublicDesktop.msi". Install it, run it.
  3. Drag the downloaded workbook onto the running app.
  4. Left column:
  • Under "Data", click "Matched (Fare Paid by Skytrain Station - Matched.xlsx)"
  • Under "Dimensions", rightclick "Abc Station" then "Add to Sheet"
  • Under "Measures", rightclick "Boardings 2009", then "Add to Sheet"
See ridership data per station, and in the status bar, see SUM(Boardings 2009) 78,845,243

--Lexein (talk) 00:27, 17 November 2011 (UTC)