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.

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.