* Monthly report
@ 2015-08-10 17:27 Norbert
0 siblings, 0 replies; 6+ messages in thread
From: Norbert @ 2015-08-10 17:27 UTC (permalink / raw)
To: emacs-orgmode
Hi folks,
I have an agenda spread across multiple files, and I would like to see a
brief report of my worktime per day for one month. Ideally such a report
would have exactly 28 .. 31 rows with two columns (the date and the
number of hours and minutes).
I have created a clocktable with stepping 1 day and depth 0, which is
close, but it still gives me for every day a summary for every file
separately.
Anybody done a report like I would like to have before?
Thanks and cheers
Norbert
^ permalink raw reply [flat|nested] 6+ messages in thread
* monthly report
@ 2007-05-25 1:41 Steven Lumos
2007-05-25 13:29 ` Jason F. McBrayer
2007-05-29 12:29 ` Carsten Dominik
0 siblings, 2 replies; 6+ messages in thread
From: Steven Lumos @ 2007-05-25 1:41 UTC (permalink / raw)
To: emacs-orgmode
Being yet another planner switcher, I'm used to using planner-report-
generate to assist me with writing a monthly activity report. I don't
need fine-grained time tracking, or even most of what planner-report-
generate does--it would be ideal to get just a list of TODOs that were
closed between two dates and then I'll look at it while I type a few
sentences in an email buffer.
Is there already an easy way to "get a list" (I guess that a sparse
tree would be most convenient for me) of TODOs marked as closed within
some date range?
If not, any words of advice before I dive in?
Steve
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: monthly report
2007-05-25 1:41 monthly report Steven Lumos
@ 2007-05-25 13:29 ` Jason F. McBrayer
2007-05-29 12:29 ` Carsten Dominik
1 sibling, 0 replies; 6+ messages in thread
From: Jason F. McBrayer @ 2007-05-25 13:29 UTC (permalink / raw)
To: emacs-orgmode
Steven Lumos <steven@lumos.us> writes:
> Is there already an easy way to "get a list" (I guess that a sparse
> tree would be most convenient for me) of TODOs marked as closed within
> some date range?
This isn't /exactly/ what you want, but I use org's clocktable
feature (see the progress logging node in the info documentation) for
my monthly reports. That's based on when you /worked on/ something,
rather than when you /closed/ it, though.
--
+-----------------------------------------------------------+
| Jason F. McBrayer jmcbray@carcosa.net |
| If someone conquers a thousand times a thousand others in |
| battle, and someone else conquers himself, the latter one |
| is the greatest of all conquerors. --- The Dhammapada |
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: monthly report
2007-05-25 1:41 monthly report Steven Lumos
2007-05-25 13:29 ` Jason F. McBrayer
@ 2007-05-29 12:29 ` Carsten Dominik
2007-05-30 0:30 ` Steven Lumos
2009-03-17 19:38 ` Micah Anderson
1 sibling, 2 replies; 6+ messages in thread
From: Carsten Dominik @ 2007-05-29 12:29 UTC (permalink / raw)
To: Steven Lumos; +Cc: emacs-orgmode
On May 25, 2007, at 3:41, Steven Lumos wrote:
> Being yet another planner switcher, I'm used to using planner-report-
> generate to assist me with writing a monthly activity report. I don't
> need fine-grained time tracking, or even most of what planner-report-
> generate does--it would be ideal to get just a list of TODOs that were
> closed between two dates and then I'll look at it while I type a few
> sentences in an email buffer.
>
> Is there already an easy way to "get a list" (I guess that a sparse
> tree would be most convenient for me) of TODOs marked as closed within
> some date range?
You can use org-occur to create a tree with matches of CLOSED time
stamps.
And you can use the callback argument of org-occur to verify if a
match is in a given time interval. Something like this:
(defun org-closed-in-range ()
"Sparse treee of items closed in a certain time range."
(interactive)
;; Get the time interval from the user.
(let* ((time1 (time-to-seconds
(org-read-date nil 'to-time nil "Starting date: ")))
(time2 (time-to-seconds
(org-read-date nil 'to-time nil "End date:")))
;; callbakc function
(callback (lambda ()
(let ((time
(time-to-seconds
(apply 'encode-time
(org-parse-time-string
(match-string 1))))))
;; check if time in interval
(and (>= time time1) (<= time time2))))))
;; make tree, check each match with the callback
(org-occur "CLOSED: +\\[\\(.*?\\)\\]" nil callback)))
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: monthly report
2007-05-29 12:29 ` Carsten Dominik
@ 2007-05-30 0:30 ` Steven Lumos
2009-03-17 19:38 ` Micah Anderson
1 sibling, 0 replies; 6+ messages in thread
From: Steven Lumos @ 2007-05-30 0:30 UTC (permalink / raw)
To: emacs-orgmode
Carsten Dominik <dominik@science.uva.nl> writes:
> On May 25, 2007, at 3:41, Steven Lumos wrote:
>> Being yet another planner switcher, I'm used to using planner-report-
>> generate to assist me with writing a monthly activity report. I don't
>> need fine-grained time tracking, or even most of what planner-report-
>> generate does--it would be ideal to get just a list of TODOs that were
>> closed between two dates and then I'll look at it while I type a few
>> sentences in an email buffer.
>>
>> Is there already an easy way to "get a list" (I guess that a sparse
>> tree would be most convenient for me) of TODOs marked as closed within
>> some date range?
>
> You can use org-occur to create a tree with matches of CLOSED time
> stamps.
> And you can use the callback argument of org-occur to verify if a
> match is in a given time interval. Something like this:
>
> (defun org-closed-in-range ()
> "Sparse treee of items closed in a certain time range."
> (interactive)
> ;; Get the time interval from the user.
> (let* ((time1 (time-to-seconds
> (org-read-date nil 'to-time nil "Starting date: ")))
> (time2 (time-to-seconds
> (org-read-date nil 'to-time nil "End date:")))
> ;; callbakc function
> (callback (lambda ()
> (let ((time
> (time-to-seconds
> (apply 'encode-time
> (org-parse-time-string
> (match-string 1))))))
> ;; check if time in interval
> (and (>= time time1) (<= time time2))))))
> ;; make tree, check each match with the callback
> (org-occur "CLOSED: +\\[\\(.*?\\)\\]" nil callback)))
This is just right. Thanks!
Steve
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: monthly report
2007-05-29 12:29 ` Carsten Dominik
2007-05-30 0:30 ` Steven Lumos
@ 2009-03-17 19:38 ` Micah Anderson
1 sibling, 0 replies; 6+ messages in thread
From: Micah Anderson @ 2009-03-17 19:38 UTC (permalink / raw)
To: emacs-orgmode
Hi all, apologies for resurrecting an older thread, but I was searching
for this very capability and found this post.
Carsten Dominik <dominik@science.uva.nl> writes:
> On May 25, 2007, at 3:41, Steven Lumos wrote:
>
>> Being yet another planner switcher, I'm used to using planner-report-
>> generate to assist me with writing a monthly activity report. I don't
>> need fine-grained time tracking, or even most of what planner-report-
>> generate does--it would be ideal to get just a list of TODOs that were
>> closed between two dates and then I'll look at it while I type a few
>> sentences in an email buffer.
>>
>> Is there already an easy way to "get a list" (I guess that a sparse
>> tree would be most convenient for me) of TODOs marked as closed within
>> some date range?
I have been trying to figure this one out myself. Thank goodness for
list archives!
> You can use org-occur to create a tree with matches of CLOSED time
> stamps.
> And you can use the callback argument of org-occur to verify if a
> match is in a given time interval. Something like this:
>
> (defun org-closed-in-range ()
> "Sparse treee of items closed in a certain time range."
> (interactive)
> ;; Get the time interval from the user.
> (let* ((time1 (time-to-seconds
> (org-read-date nil 'to-time nil "Starting date: ")))
> (time2 (time-to-seconds
> (org-read-date nil 'to-time nil "End date:")))
> ;; callbakc function
> (callback (lambda ()
> (let ((time
> (time-to-seconds
> (apply 'encode-time
> (org-parse-time-string
> (match-string 1))))))
> ;; check if time in interval
> (and (>= time time1) (<= time time2))))))
> ;; make tree, check each match with the callback
> (org-occur "CLOSED: +\\[\\(.*?\\)\\]" nil callback)))
Ok, I tried this and I'm not sure what it did, if anything. I get the
mini-buffer saying, 'Specified time is not representable' I've tried
various date range possibilities, and can't get it to work.
I did also change the '(org-occur "CLOSED: +\\[\\(.*?\\)\\]" nil
callback)))' to be instead '(org-occur "DONE +\\[\\(.*?\\)\\]" nil
callback)))' due to the way my org seems to represent finished items:
** DONE fix the apt puppet module to automatically add apt-keys, publish that new repository and deploy
SCHEDULED: <2009-03-16 Mon>
- State "DONE" [2009-03-16 Mon 14:49] \\
made this a lot nicer
CLOCK: [2009-03-16 Mon 14:21]--[2009-03-16 Mon 14:21] => 0:00
[2009-03-16 Mon]
As far as I can tell, I did not setup this format. I tried to change the
(org-occur "CLOSED... to be "DONE..." instead, but no change here
either.
Thanks for any help!
micah
^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2015-08-10 20:25 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2015-08-10 17:27 Monthly report Norbert
-- strict thread matches above, loose matches on Subject: below --
2007-05-25 1:41 monthly report Steven Lumos
2007-05-25 13:29 ` Jason F. McBrayer
2007-05-29 12:29 ` Carsten Dominik
2007-05-30 0:30 ` Steven Lumos
2009-03-17 19:38 ` Micah Anderson
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.