I've searched extensively online but have not found an easy solution. Maybe there is already an easy solution or some tips on doing this easily?
I am clocking in the amount of time I spend on different projects. I can summarize the clocktable using org-clock-report
. However, I would like to visualize this data using either barplots for different projects (easiest), or a breakdown of how much time I spend on different projects as a function of the calendar year (most complicated).
Has anyone already tried this? Is there an easy way to parse the timestamps into a file format that makes it easy to plot in standard software such as excel or R?
Example org file:
*** Analysis
CLOCK: [2016-06-06 Mon 21:13]--[2016-06-06 Mon 22:29] => 1:16
CLOCK: [2016-06-06 Mon 14:20]--[2016-06-06 Mon 17:31] => 3:11
CLOCK: [2016-06-06 Mon 09:50]--[2016-06-06 Mon 12:15] => 2:25
*** Meeting
CLOCK: [2016-06-07 Tue 09:07]--[2016-06-07 Tue 11:46] => 2:39
CLOCK: [2016-06-06 Mon 13:43]--[2016-06-06 Mon 14:20] => 0:37
The idea would be to wrangle these timestamps into a file format that would be easily amenable to plotting (excel or R).