From mboxrd@z Thu Jan 1 00:00:00 1970 From: savoie@nsidc.org Subject: Bug: clocktable question [9.1.6 (9.1.6-dist @ /Users/savoie/tmp/org-bug/org-9.1.6/lisp/)] Date: Mon, 08 Jan 2018 14:58:15 -0700 Message-ID: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54939) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eYfR8-0000An-0I for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 16:58:31 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eYfR2-00010x-Tc for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 16:58:30 -0500 Received: from ipmx6.colorado.edu ([128.138.67.76]:59849) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1eYfR2-0000sz-IH for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 16:58:24 -0500 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 - GNU Emacs 25.2.1 (x86_64-apple-darwin13.4.0, NS appkit-1265.21 Version 10.9.5 (Build 13F1911)) of 2017-04-21 - Org mode version 9.1.6 (9.1.6-10-g0c9329-elpa @ /Users/savoie/.emacs.d/elpa/org-20180108/) Having a hard time understanding clocktables. I either have a bug or a misunderstanding. Why don't my hours off for Wednesday show up when I create a clocktable starting on Monday at 00 and ending on Wednesday at 23:59 if I use :step? I expect that when I have clock stamp: CLOCK: [2017-12-27 Wed 08:00]--[2017-12-27 Wed 16:00] => 8:00 and I'm generating a clocktable with a start time before the beginning and an end time after the end, I would see that reflected in the table. Below are 4 stanzas. The first are some clocked hours. The second is a clock table that works as expected. The second and third stanzas seem to exclude the hours from Wednesday (which I don't expect). I don't know why the 4th stanza appears as it does. ``` * Here's some vacation hours. :LOGBOOK: CLOCK: [2017-12-25 Mon 08:00]--[2017-12-25 Mon 16:00] => 8:00 CLOCK: [2017-12-26 Tue 08:00]--[2017-12-26 Tue 16:00] => 8:00 CLOCK: [2017-12-27 Wed 08:00]--[2017-12-27 Wed 16:00] => 8:00 :END: * Clocktable with no steps Seems ok. #+BEGIN: clocktable :tstart "<2017-12-25 Mon 00:00>" :tend "<2017-12-27 Wed 23:59>" :scope file #+CAPTION: Clock summary at [2018-01-08 Mon 14:52] | Headline | Time | |-----------------------------+-----------| | *Total time* | *1d 0:00* | |-----------------------------+-----------| | Here's some vacation hours. | 1d 0:00 | #+END: * Time it weekly (I think it's missing Wednesday) #+BEGIN: clocktable :tstart "<2017-12-25 Mon 00:00>" :tend "<2017-12-27 Wed 23:59>" :scope file :step week Weekly report starting on: [2017-12-25 Mon] | Headline | Time | |-----------------------------+---------| | *Total time* | *16:00* | |-----------------------------+---------| | Here's some vacation hours. | 16:00 | #+END: * Time it daily (Sure looks like Wed is missing) #+BEGIN: clocktable :tstart "<2017-12-25 Mon 00:00>" :tend "<2017-12-27 Wed 23:59>" :scope file :step day Daily report: [2017-12-25 Mon] | Headline | Time | |-----------------------------+--------| | *Total time* | *8:00* | |-----------------------------+--------| | Here's some vacation hours. | 8:00 | Daily report: [2017-12-26 Tue] | Headline | Time | |-----------------------------+--------| | *Total time* | *8:00* | |-----------------------------+--------| | Here's some vacation hours. | 8:00 | Daily report: [2017-12-27 Wed] | Headline | Time | |--------------+--------| | *Total time* | *0:00* | #+END: * Time it daily, but use illegal time for Wed end #+BEGIN: clocktable :tstart "<2017-12-25 Mon 00:00>" :tend "<2017-12-27 Wed 24:00>" :scope file :step day Daily report: [2017-12-25 Mon] | Headline | Time | |-----------------------------+--------| | *Total time* | *8:00* | |-----------------------------+--------| | Here's some vacation hours. | 8:00 | Daily report: [2017-12-26 Tue] | Headline | Time | |-----------------------------+--------| | *Total time* | *8:00* | |-----------------------------+--------| | Here's some vacation hours. | 8:00 | Daily report: [2017-12-27 Wed] | Headline | Time | |-----------------------------+--------| | *Total time* | *8:00* | |-----------------------------+--------| | Here's some vacation hours. | 8:00 | #+END: ``` Remember to cover the basics, that is, what you expected to happen and what in fact did happen. You don't know how to make a good report? See http://orgmode.org/manual/Feedback.html#Feedback Your bug report will be posted to the Org mailing list. ------------------------------------------------------------------------ Emacs : GNU Emacs 25.2.1 (x86_64-apple-darwin13.4.0, NS appkit-1265.21 Version 10.9.5 (Build 13F1911)) of 2017-04-21 Package: Org mode version 9.1.6 (9.1.6-dist @ /Users/savoie/tmp/org-bug/org-9.1.6/lisp/) current state: ============== (setq org-tab-first-hook '(org-babel-hide-result-toggle-maybe org-babel-header-arg-expand) org-speed-command-hook '(org-speed-command-activate org-babel-speed-command-activate) org-occur-hook '(org-first-headline-recenter) org-metaup-hook '(org-babel-load-in-session-maybe) org-confirm-shell-link-function 'yes-or-no-p org-after-todo-state-change-hook '(org-clock-out-if-current) org-src-mode-hook '(org-src-babel-configure-edit-buffer org-src-mode-configure-edit-buffer) org-agenda-before-write-hook '(org-agenda-add-entry-text) org-babel-pre-tangle-hook '(save-buffer) org-mode-hook '((closure (org-inlinetask-min-level buffer-face-mode-face org-mode-map org-tbl-menu org-org-menu org-struct-menu org-entities org-last-state org-id-track-globally org-clock-start-time texmathp-why remember-data-file org-agenda-tags-todo-honor-ignore-options iswitchb-temp-buflist calc-embedded-open-mode calc-embedded-open-formula calc-embedded-close-formula align-mode-rules-list org-emphasis-alist org-emphasis-regexp-components org-export-registered-backends org-modules org-babel-load-languages org-element-paragraph-separate ffap-url-regexp t) nil (add-hook (quote change-major-mode-hook) (quote org-show-block-all) (quote append) (quote local)) ) (closure (org-bracket-link-regexp org-src-window-setup *this* org-babel-confirm-evaluate-answer-no org-src-preserve-indentation org-src-lang-modes org-edit-src-content-indentation org-babel-library-of-babel t) nil (add-hook (quote change-major-mode-hook) (quote org-babel-show-result-all) (quote append) (quote local)) ) org-babel-result-hide-spec org-babel-hide-all-hashes) org-bibtex-headline-format-function '(closure (org-id-locations org-agenda-search-view-always-boolean org-agenda-overriding-header t) (entry) (cdr (assq :title entry))) org-archive-hook '(org-attach-archive-delete-maybe) org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers org-cycle-show-empty-lines org-optimize-window-after-visibility-change) org-confirm-elisp-link-function 'yes-or-no-p org-metadown-hook '(org-babel-pop-to-session-maybe) 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)) org-clock-out-hook '(org-clock-remove-empty-clock-drawer) )