Quantified Self - Metrocard Months

I wanted to see in graphical form how many days of the month I used my metro card in recent months as a way to figure out whether it’s worth going back to unlimited monthly fares.

To get the data, I logged into my easypass account and then downloaded the data into csv files. Imported that CSV file into tableau to play with the drag and drop interface.

Calendar by MacbookandHeels.com

Here’s how I constructed the calendar view:

In the columns, I used the WEEKDAY() function to transform the transaction day into the day of weeks.

In the rows, I used the Month() function to show the month and then the WEEK() to break down the view into weeks.