The easiest option is using their manual exports on the site. RescueTime provides great data accessibility, and there are several ways to get your data. Data accessibility describes the idea that you should have access to data you create inside a service. While a lot of focus is put on data privacy, for me data accessibility is just as important. So, now that you are tracking your computer usage with RescueTime, what can you do to collect and engage with our data outside of the site? Collecting Your Time Data from RescueTime While there are some other great alternative time tracking tools, RescueTime remains one of my favorites and one I recommend for anyone looking to setup their self-tracking and quantified self toolkit. Overall, the tracking experience with RescueTime is great, and the time reports provided are detailed, useful and clear. Your computer usage data is then synced to their site where you can view various reports and see a breakdown of different categories and your productivity score. RescueTime is a great productivity tool for anyone trying to improve their time management or to become a bit more data-driven in their productivity and goals.Īfter installing a simple background application on your computer, RescueTime will track your usage of various applications and time spent on different websites. Let’s get started with some advanced data processing with Google Sheets! Time Tracking and Passive Computer Usage from RescueTime Finally, once we’ve done the hard technical work of data processing and data preparation, you’ll discover how easy it is to do some personal data analysis using pivot tables and charts and graphs. I’ll show you how to use array formulas to process columns of data in bulk. You’ll learn how to add and leverage custom code with Google App Scripts to extract information and do calculations. The goal of this post show you some advanced functions for data processing inside Google Sheets. We are turning our tracking data into improved self-understanding. Finally, we will use some simple pivot tables and charts to do some personal data analysis. We will use some custom functions in Google Sheets to create some time dimensions from our date field. We will then leverage some code in Google App Script to process and prepare our data. First, we will use IFTTT for data collection from RescueTime into Google Sheets. In this post, I want to walkthrough setting up a simple time tracking dashboard with RescueTime, IFTTT and Google Sheets. Over time I discovered how time tracking made me conscious of my time usage, I learned to use time data in my weekly reviews and even explored a year of time tracking too. Personally, I started to track using time tracking tools when I become a freelance developer several years. I see a lot of value in time tracking and time data. In turn, the ubiquity of Google Sheets means it’s easy to then pull data from there into your favorite visualization tools like Google Data Studio, Tableau or Plot.ly. Once your data is in Google Sheets, you can leverage custom functions and App Script to process and prepare that data. That way all of your data is stored into Google Sheets for easy access and even simple data visualization and data analysis. While you can use manual exports or code like QS Ledger to collect data from different tracking services, an automation service like IFTTT can automate the data collection. Increasingly I’ve been using various automation services as one of my data collection methods. But how to collect your data and what to do with all that data once you get it? It’s a great passive way to know where your time is going on your computer. RescueTime is one of my favorite ways to track my life.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |