# TimeTrack data export and mapping

Data graphs that are pleasing to the eye can significantly drive your record of adherence, and don't believe me, I am an example.

That's why I stick to Excel data visualization, after all.

> "Beauty is the number one productivity."

First of all, how to export TimeTrack data, open TimeTrack - more - report - select the time period (such as "today") - top right - export report - CSV - share - select the receiving software, I will generally select QQ my computer.

Open with WPS or Excel can be opened, if you use Excel to open the CSV file found messy, right-click the CSV file, open the way to select Notepad, click File Save As, modify the encoding for ANSI encoding format, save, and then open Excel will show normal.

Open the exported data and it looks like this.

![](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LmU_KsfMm5m1AbZlhQc%2F-LmUcZB2VAgdf4eb86Yz%2F%E5%9B%BE%E7%89%87.png?alt=media\&token=5cfe4154-f980-465e-acb5-a71652230ef8)

Select columns A through F and double-click in the space between columns to adjust the appropriate column width.

We found that the exported data is divided into two parts, the top part of the blank row is the breakdown, the start and end time, duration and note content of all activities, etc., and the bottom part of the blank row is the activity percentage, the duration and percentage of each activity in the time period you choose to export.

The next part of the data lets you visualize which category consumes the most of your time, while the upper part requires you to use some means to analyze it, such as using Excel's pivot table feature.

You can fully select the first part of the data - insert - data pivot table - OK, then put the start time and activity type in the "row", put the duration in the "value", click the duration in the lower right corner of the triangle - value field settings, summary mode select "sum", the number format to "\[h]:mm:ss", OK, then right click at the start time, select the combination, step selection day and month, OK.

The final selection of nearly 4 weeks of data, in descending order, is shown in Fig.

![Weekly Perspective View](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LmU_KsfMm5m1AbZlhQc%2F-LmUci4fwq_ztYEvVBCc%2F%E5%9B%BE%E7%89%87.png?alt=media\&token=daf6d22a-3783-4c32-b785-809803fc25d1)

If you want a chart, insert-select the cluster bar chart and you have the simplest chart possible.

![](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LmU_KsfMm5m1AbZlhQc%2F-LmUeEvzC630gYPdXt52%2F%E5%9B%BE%E7%89%87.png?alt=media\&token=9b538e91-644b-419b-9a22-c96be8c0a1a5)

The ability to export data for analysis greatly enhances the playability of the data, this advanced operation not only exercises your hands-on ability, ultimately beautiful mapping, but also a kind of positive feedback, next, I will share more data usage to you.

Also, not every export is "smooth", as you may find that there are overlapping data.

![coincidence time](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LnrlPd_1apHhc0CLdwj%2F-Lnrm1jGM1S3oCTTMavh%2FQQ%E5%9B%BE%E7%89%8720190903233937.png?alt=media\&token=d668f1f1-0b68-45ec-91c9-7beb49942c77)

If you find that there are overlapping times like "S4:Unhanded, S2:Planned" before you export the data, you first need to locate the overlapping data and fix them.

Go back to the Activity History List page, select Pie Chart, Day, observe which day the data overlaps, then switch to List View, Modify.

![](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LnrlPd_1apHhc0CLdwj%2F-LnrmkgQBXbDnG3lgWSv%2FQQ%E5%9B%BE%E7%89%8720190903234250.jpg?alt=media\&token=760aa0e3-49be-4b80-9d8f-f56bac917305)

If you are also a full time recorder, then when exporting the data, you also need to see if the total time is around "167:59", with a 5 minute error.

![](https://gblobscdn.gitbook.com/assets%2F-LhBSfOLQDck_EdELnqq%2F-LnrlPd_1apHhc0CLdwj%2F-Lnro3T_lr3dmyKMfppv%2FQQ%E5%9B%BE%E7%89%8720190903234827.png?alt=media\&token=8f65e866-df66-489e-a60b-122a74489923)

If the error is too large, you should find out on a daily basis if you have missed something and make up for it.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://en.shijian.tujunjie.com/ch04/ch04.27.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.