Example 1: How is my sleep?
Lately I've been feeling mentally ill and dizzy during the day, is it because of sleep?
I opened the TimeTrack data and did the following to verify.
Open the time data, create two new columns in the monthly data table, and use the hour function to derive the hour value of the start time and end time, respectively.
In the monthly pivot table, create two pivot tables, filter "sleep" and put the hourly values of the start time and the end time in the "row" respectively.
Got it out that I sleep 85% of the time in the wee hours to 1am and get up 75% of the time in the morning between 8 and 9am, guaranteeing 8 hours of sleep.
It was found that late sleeping was evident, but there were no problems with the sleep duration criteria.
Then analyze the number of times the sleep was active to see if there were any fragmentation cases where sleep was interrupted multiple times.
In the pivot table, the "value" display is changed from duration to count and the format is changed to normal.
We get the number of times we turn on "sleep" in a month, and we use the number of times/day to get the ratio of the average number of times we turn on "sleep" per day, which is 1.2.
Then what we can conclude from the time data is.
  1. 1.
    Significantly late-sleeping, but standard length of sleep.
  2. 2.
    Standard number of sleeps with no significant interruptions.
So poor mental state may not be the cause of sleep, but of course we can at least come up with some suggestions for action, such as adjusting your diet, going to bed early, or taking a lunch break.
If you have a classmate with a bracelet, you can also look at the weekly data of the bracelet, as shown in the figure:
The advice given is that improvement is needed, aided by judgment.
The first example, using sleep time analysis, is to show you how to use the number of times and summation to find problems.
Some classmates might say.
Are you kidding me? Don't I know whether I sleep well or not? It still needs analysis, and small talk!
We all have a concept of what is good or bad, but it is not enough to have a concept. Which part do we start with? Is it an issue of sleep time, or is it an issue of sleep quality? Having a track record will help you pinpoint the problem that can facilitate your correction.
Why else do you know you have poor self-control but can't change it? It's because you don't know what the difference is.
复制链接