Diving deeper with personal analytics

In my first post of 2022, I shared some analytics of my life tracking data for the last 6 years. I couldn't help myself going down the rabbit hole with additional questions that could be used to trigger additional self reflection, which would then spark me to make deliberate changes in my life. It was quite fun going down the rabbit hole playing with AWS Quicksight and manipulating data fields to get to the answers I sought. 

When I have more time to play around, I think an AI/ML personal assistant should use my data to help me with insights. I believe there will be a market in personal analytics or metrics, or personal telemetry that I've coined the termed personametry back in 2015. At that time I wanted to build a product based on my RAGE model called personametry. Alas, that project is still on the backburner, and I've made a ton of excuses (to be honest) not getting it off the ground. Yes, my work got in the way, reality of family and financial obligations, then complacency and comforts-of-life (aka laziness). If I was serious about it, I would've made a plan. I resigned to keep tracking my data, keeping abreast of the progress of personal assistants, productivity apps and personal tracking devices, looking for the timing when things begin to fall into place!!

If you have additional questions you think might inspire changes & personal improvements, let me know in the comments section!

How do I breakdown my 24-hour days?

This is an interesting question. I decided to splice my 24-hours into "periods" and so I ended up with 8 (eight) partitions of the day. Since I track the start and end of my activities (tasks) captured in Harvest, I should be able to see how I utilize my time in a typical day. There is a missing element of productivity/impact as a result of that activity, which is a topic for another day.

Here is the code for splitting up a day, using a datetime field, in Quicksight:

I don't start my day at midnight and count 24 hours. Rather I account for the 24 hours from the point of going to bed or starting my day at 4am. I used to consistently begin my days at 4am for 2016-2020, but since relocating to Cape Town, it's been a struggle. I'm going to have to renew this habit in 2022. The partitioning of 24 hours days is not impacted though.

In addition to splicing the parts of day, I could look at how my routines differ between weekdays and weekends. For weekdays, I haven't yet filtered out real workdays, that is, not a public holiday or a leave day. 

With this new partitioning I can then answer these questions like:

• What does my typical weekday look like?
• What does my typical weekend look like?
• Which hours of the day do I usually work?
• Which hours of the day do I mostly exercise on weekdays?
• Which hours of the day do I mostly exercise on weekends?
• During weekdays, at which points in the day do I spend time with family?
• When do I get my reading done on a weekday?
• When do I get my reading done on a weekend?
• What parts of the day do I usually get my sleep on weekdays?
• What parts of the day do I usually get my sleep on weekends?
• Does my sleep differ by weekdays and weekends?
• Did I get any early mornings of spiritual in?
• At which parts of day is my typical "me time"?
• How many weekdays and weekends did I work?
• How has my weekdays transformed now and before Covid?

Additional Visualisations...