emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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

* 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

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 public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).