From mboxrd@z Thu Jan 1 00:00:00 1970 From: Soubzriquet Subject: is this a known issue in clocktable output? Date: Wed, 27 Nov 2019 16:42:15 -0800 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="0000000000004f28c405985d63e9" Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:51652) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ia7tB-0004JB-Na for emacs-orgmode@gnu.org; Wed, 27 Nov 2019 19:42:35 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ia7t9-0008Ib-NA for emacs-orgmode@gnu.org; Wed, 27 Nov 2019 19:42:33 -0500 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]:39424) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1ia7t9-0008EE-Af for emacs-orgmode@gnu.org; Wed, 27 Nov 2019 19:42:31 -0500 Received: by mail-ed1-x532.google.com with SMTP id n26so21245386edw.6 for ; Wed, 27 Nov 2019 16:42:30 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org --0000000000004f28c405985d63e9 Content-Type: text/plain; charset="UTF-8" Hi all, I'm new to using org-mode for time tracking, and have run into an odd issue with using "day" steps where the date is getting offset sometimes. I saw the issue with 26.1, was not fixed by updating to current environment with an empty init.el on OS X: Emacs : GNU Emacs 26.3 (build 1, x86_64-apple-darwin18.2.0, NS appkit-1671.20 Version 10.14.3 (Build 18D109)) of 2019-09-02 Package: Org mode version 9.1.9 (release_9.1.9-65-g5e4542 @ /Applications/Emacs.app/Contents/Resources/lisp/org/) current state: ============== (setq org-src-mode-hook '(org-src-babel-configure-edit-buffer org-src-mode-configure-edit-buffer) org-after-todo-state-change-hook '(org-clock-out-if-current) org-metadown-hook '(org-babel-pop-to-session-maybe) org-clock-out-hook '(org-clock-remove-empty-clock-drawer) org-mode-hook '(#[0 "\300\301\302\303\304$\207" [add-hook change-major-mode-hook org-show-block-all append local] 5] #[0 "\300\301\302\303\304$\207" [add-hook change-major-mode-hook org-babel-show-result-all append local] 5] org-babel-result-hide-spec org-babel-hide-all-hashes) org-archive-hook '(org-attach-archive-delete-maybe) org-confirm-elisp-link-function 'yes-or-no-p org-agenda-before-write-hook '(org-agenda-add-entry-text) org-metaup-hook '(org-babel-load-in-session-maybe) org-bibtex-headline-format-function #[257 "\300 \236A\207" [:title] 3 "\n\n(fn ENTRY)"] org-babel-pre-tangle-hook '(save-buffer) org-tab-first-hook '(org-babel-hide-result-toggle-maybe org-babel-header-arg-expand) org-occur-hook '(org-first-headline-recenter) org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers org-cycle-show-empty-lines org-optimize-window-after-visibility-change) org-speed-command-hook '(org-speed-command-activate org-babel-speed-command-activate) org-confirm-shell-link-function 'yes-or-no-p org-link-parameters '(("id" :follow org-id-open) ("rmail" :follow org-rmail-open :store org-rmail-store-link) ("mhe" :follow org-mhe-open :store org-mhe-store-link) ("irc" :follow org-irc-visit :store org-irc-store-link) ("info" :follow org-info-open :export org-info-export :store org-info-store-link) ("gnus" :follow org-gnus-open :store org-gnus-store-link) ("docview" :follow org-docview-open :export org-docview-export :store org-docview-store-link) ("bibtex" :follow org-bibtex-open :store org-bibtex-store-link) ("bbdb" :follow org-bbdb-open :export org-bbdb-export :complete org-bbdb-complete-link :store org-bbdb-store-link) ("w3m" :store org-w3m-store-link) ("file+sys") ("file+emacs") ("doi" :follow org--open-doi-link) ("elisp" :follow org--open-elisp-link) ("file" :complete org-file-complete-link) ("ftp" :follow (lambda (path) (browse-url (concat "ftp:" path)))) ("help" :follow org--open-help-link) ("http" :follow (lambda (path) (browse-url (concat "http:" path)))) ("https" :follow (lambda (path) (browse-url (concat "https:" path)))) ("mailto" :follow (lambda (path) (browse-url (concat "mailto:" path)))) ("news" :follow (lambda (path) (browse-url (concat "news:" path)))) ("shell" :follow org--open-shell-link)) ) Below is a simple org file which demonstrates the problem. The aggregate numbers are correct for the file, but when I make a clocktable stepping by day, the [2019-11-03 Sun] entry is repeated and every date after that is off by one. Using stepskip0 doesn't change that . --- * Day 1 :LOGBOOK: CLOCK: [2019-11-01 Fri 10:00]--[2019-11-01 Fri 11:00] => 1:00 :END: * Day 2 :LOGBOOK: CLOCK: [2019-11-02 Sat 10:00]--[2019-11-02 Sat 12:00] => 2:00 :END: * Day 3 :LOGBOOK: CLOCK: [2019-11-03 Sun 10:00]--[2019-11-03 Sun 13:00] => 3:00 :END: * Day 4 :LOGBOOK: CLOCK: [2019-11-04 Mon 10:00]--[2019-11-04 Mon 14:00] => 4:00 :END: * Day 5 :LOGBOOK: CLOCK: [2019-11-05 Tue 10:00]--[2019-11-05 Tue 15:00] => 5:00 :END: * Day 6 :LOGBOOK: CLOCK: [2019-11-06 Wed 10:00]--[2019-11-06 Wed 16:00] => 6:00 :END: #+BEGIN: clocktable :scope file :maxlevel 2 #+CAPTION: Clock summary at [2019-11-27 Wed 16:41] | Headline | Time | |--------------+---------| | *Total time* | *21:00* | |--------------+---------| | Day 1 | 1:00 | | Day 2 | 2:00 | | Day 3 | 3:00 | | Day 4 | 4:00 | | Day 5 | 5:00 | | Day 6 | 6:00 | #+END: #+BEGIN: clocktable :scope file :maxlevel 2 :block thismonth :step day :stepskip0 t Daily report: [2019-11-01 Fri] | Headline | Time | |--------------+--------| | *Total time* | *1:00* | |--------------+--------| | Day 1 | 1:00 | Daily report: [2019-11-02 Sat] | Headline | Time | |--------------+--------| | *Total time* | *2:00* | |--------------+--------| | Day 2 | 2:00 | Daily report: [2019-11-03 Sun] | Headline | Time | |--------------+--------| | *Total time* | *3:00* | |--------------+--------| | Day 3 | 3:00 | Daily report: [2019-11-03 Sun] | Headline | Time | |--------------+--------| | *Total time* | *4:00* | |--------------+--------| | Day 4 | 4:00 | Daily report: [2019-11-04 Mon] | Headline | Time | |--------------+--------| | *Total time* | *5:00* | |--------------+--------| | Day 5 | 5:00 | Daily report: [2019-11-05 Tue] | Headline | Time | |--------------+--------| | *Total time* | *6:00* | |--------------+--------| | Day 6 | 6:00 | #+END: --0000000000004f28c405985d63e9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi all,
I'm new to using org-mode for t= ime tracking, and have run into an odd issue with using "day" ste= ps where the date is getting offset sometimes.

I s= aw the issue with 26.1, was not fixed by updating=C2=A0 to current environm= ent with an empty init.el on OS X:
Emacs =C2=A0: GNU Emacs 26.3 (build= 1, x86_64-apple-darwin18.2.0, NS appkit-1671.20 Version 10.14.3 (Build 18D= 109))
=C2=A0of 2019-09-02
Package: Org mode version 9.1.9 (release_9.= 1.9-65-g5e4542 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)
<= br>current state:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
(setq=C2=A0org-src-mode-hook '(org-src-babel-configure-edit-buffer
= =C2=A0 =C2=A0 org-src-mode-configure-edit-buffer)
=C2=A0org-after-todo-s= tate-change-hook '(org-clock-out-if-current)
=C2=A0org-metadown-hook= '(org-babel-pop-to-session-maybe)
=C2=A0org-clock-out-hook '(or= g-clock-remove-empty-clock-drawer)
=C2=A0org-mode-hook '(#[0 "\= 300\301\302\303\304$\207"
=C2=A0 [add-hook change-major-mode-hoo= k org-show-block-all append
=C2=A0 =C2=A0local]
=C2=A0 5]
= #[0 "\300\301\302\303\304$\207"
=C2=A0 [add-hook change-ma= jor-mode-hook org-babel-show-result-all
=C2=A0 =C2=A0append local] =C2=A0 5]
org-babel-result-hide-spec org-babel-hide-all-hashes)=C2=A0org-archive-hook '(org-attach-archive-delete-maybe)
=C2=A0or= g-confirm-elisp-link-function 'yes-or-no-p
=C2=A0org-agenda-before-w= rite-hook '(org-agenda-add-entry-text)
=C2=A0org-metaup-hook '(o= rg-babel-load-in-session-maybe)
=C2=A0org-bibtex-headline-format-functio= n #[257 "\300 \236A\207" [:title] 3 "\n\n(fn ENTRY)"]=C2=A0org-babel-pre-tangle-hook '(save-buffer)
=C2=A0org-tab-first= -hook '(org-babel-hide-result-toggle-maybe
=C2=A0 =C2=A0 =C2=A0or= g-babel-header-arg-expand)
=C2=A0org-occur-hook '(org-first-headline= -recenter)
=C2=A0org-cycle-hook '(org-cycle-hide-archived-subtrees o= rg-cycle-hide-drawers
=C2=A0org-cycle-show-empty-lines
=C2=A0or= g-optimize-window-after-visibility-change)
=C2=A0org-speed-command-hook = '(org-speed-command-activate
=C2=A0org-babel-speed-command-activ= ate)
=C2=A0org-confirm-shell-link-function 'yes-or-no-p
=C2=A0org= -link-parameters '(("id" :follow org-id-open)
=C2=A0 = =C2=A0 =C2=A0 ("rmail" :follow org-rmail-open :store
org-rm= ail-store-link)
=C2=A0 =C2=A0 =C2=A0 ("mhe" :follow org-mhe= -open :store org-mhe-store-link)
=C2=A0 =C2=A0 =C2=A0 ("irc"= ; :follow org-irc-visit :store org-irc-store-link)
=C2=A0 =C2=A0 =C2= =A0 ("info" :follow org-info-open :export org-info-export
:= store org-info-store-link)
=C2=A0 =C2=A0 =C2=A0 ("gnus" :fo= llow org-gnus-open :store
org-gnus-store-link)
=C2=A0 =C2=A0 = =C2=A0 ("docview" :follow org-docview-open :export
org-docv= iew-export :store org-docview-store-link)
=C2=A0 =C2=A0 =C2=A0 ("= ;bibtex" :follow org-bibtex-open :store
org-bibtex-store-link) =C2=A0 =C2=A0 =C2=A0 ("bbdb" :follow org-bbdb-open :export o= rg-bbdb-export
:complete org-bbdb-complete-link :store
org-bbdb= -store-link)
=C2=A0 =C2=A0 =C2=A0 ("w3m" :store org-w3m-sto= re-link) ("file+sys")
=C2=A0 =C2=A0 =C2=A0 ("file+emac= s") ("doi" :follow org--open-doi-link)
=C2=A0 =C2=A0 = =C2=A0 ("elisp" :follow org--open-elisp-link)
=C2=A0 =C2=A0= =C2=A0 ("file" :complete org-file-complete-link)
=C2=A0 = =C2=A0 =C2=A0 ("ftp" :follow
(lambda (path) (browse-url (co= ncat "ftp:" path))))
=C2=A0 =C2=A0 =C2=A0 ("help"= :follow org--open-help-link)
=C2=A0 =C2=A0 =C2=A0 ("http" = :follow
(lambda (path) (browse-url (concat "http:" path))))=
=C2=A0 =C2=A0 =C2=A0 ("https" :follow
(lambda (path)= (browse-url (concat "https:" path))))
=C2=A0 =C2=A0 =C2=A0= ("mailto" :follow
(lambda (path) (browse-url (concat "= ;mailto:" path))))
=C2=A0 =C2=A0 =C2=A0 ("news" :follo= w
(lambda (path) (browse-url (concat "news:" path))))
= =C2=A0 =C2=A0 =C2=A0 ("shell" :follow org--open-shell-link))
= =C2=A0)


Below=C2=A0 is a simple org file which demonstrates the problem.=C2=A0= =C2=A0 The aggregate numbers are correct for the file, but when I make a cl= ocktable stepping by day, the [2019-11-03 Sun] entry is repeated and every = date after that is off by one.=C2=A0 Using stepskip0 doesn't change tha= t .

---

* Day 1
= =C2=A0 :LOGBOOK:
=C2=A0 CLOCK: [2019-11-01 Fri 10:00]--[2019-11-01 Fri 1= 1:00] =3D> =C2=A01:00
=C2=A0 :END:
* Day 2
=C2=A0 :LOGBOOK:
= =C2=A0 CLOCK: [2019-11-02 Sat 10:00]--[2019-11-02 Sat 12:00] =3D> =C2=A0= 2:00
=C2=A0 :END:
* Day 3
=C2=A0 :LOGBOOK:
=C2=A0 CLOCK: [2019-= 11-03 Sun 10:00]--[2019-11-03 Sun 13:00] =3D> =C2=A03:00
=C2=A0 :END:=
* Day 4
=C2=A0 :LOGBOOK:
=C2=A0 CLOCK: [2019-11-04 Mon 10:00]--[2= 019-11-04 Mon 14:00] =3D> =C2=A04:00
=C2=A0 :END:
* Day 5
=C2= =A0 :LOGBOOK:
=C2=A0 CLOCK: [2019-11-05 Tue 10:00]--[2019-11-05 Tue 15:0= 0] =3D> =C2=A05:00
=C2=A0 :END:
* Day 6
=C2=A0 :LOGBOOK:
=C2= =A0 CLOCK: [2019-11-06 Wed 10:00]--[2019-11-06 Wed 16:00] =3D> =C2=A06:0= 0
=C2=A0 :END:

#+BEGIN: clocktable :scope file :maxlevel 2
#+C= APTION: Clock summary at [2019-11-27 Wed 16:41]
| Headline =C2=A0 =C2=A0= | =C2=A0 =C2=A0Time |
|--------------+---------|
| *Total time* | *2= 1:00* |
|--------------+---------|
| Day 1 =C2=A0 =C2=A0 =C2=A0 =C2= =A0| =C2=A0 =C2=A01:00 |
| Day 2 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2= =A02:00 |
| Day 3 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A03:00 |
| = Day 4 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A04:00 |
| Day 5 =C2=A0 = =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A05:00 |
| Day 6 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| =C2=A0 =C2=A06:00 |
#+END:


#+BEGIN: clocktable :scope= file :maxlevel 2 :block thismonth :step day :stepskip0 t

Daily repo= rt: [2019-11-01 Fri]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|------= --------+--------|
| *Total time* | *1:00* |
|--------------+--------= |
| Day 1 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1:00 =C2=A0 |

Daily report= : [2019-11-02 Sat]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|--------= ------+--------|
| *Total time* | *2:00* |
|--------------+--------|<= br>| Day 2 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 2:00 =C2=A0 |

Daily report: = [2019-11-03 Sun]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|----------= ----+--------|
| *Total time* | *3:00* |
|--------------+--------|| Day 3 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 3:00 =C2=A0 |

Daily report: [2= 019-11-03 Sun]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|------------= --+--------|
| *Total time* | *4:00* |
|--------------+--------|
|= Day 4 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 4:00 =C2=A0 |

Daily report: [201= 9-11-04 Mon]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|--------------= +--------|
| *Total time* | *5:00* |
|--------------+--------|
| D= ay 5 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 5:00 =C2=A0 |

Daily report: [2019-= 11-05 Tue]
| Headline =C2=A0 =C2=A0 | Time =C2=A0 |
|--------------+-= -------|
| *Total time* | *6:00* |
|--------------+--------|
| Day= 6 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 6:00 =C2=A0 |

#+END:
<= br>

--0000000000004f28c405985d63e9--