From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
Subject: One table column per outline level for columnviews
Date: Wed, 09 Nov 2011 17:02:06 +0100
Message-ID: <80boslwagx.fsf@somewhere.org>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode-mXXj517/zsQ@public.gmane.org>
List-Help: <mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request-mXXj517/zsQ@public.gmane.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org

Hello,

Let's say I'm making an estimate for a work, and have this Org file:

#+begin_src org
  #+COLUMNS: %40ITEM(Task) %6Effort(Estim.){:}

  * Development
    :PROPERTIES:
    :ID:       fc314ab6-5bdc-4a2d-9c2d-d9aece03a864
    :END:

  ** Task 1
     :PROPERTIES:
     :Effort:   1:00
     :END:

  ** Task 2

  *** Task 2a
      :PROPERTIES:
      :Effort:   1:00
      :END:

  *** Task 2b
      :PROPERTIES:
      :Effort:   1:00
      :END:
#+end_src

Now, if I want a summary of the work to be done, along with totals, I put
(for example, up to 3 levels):

  #+BEGIN: columnview :hlines 1 :id "fc314ab6-5bdc-4a2d-9c2d-d9aece03a864" :maxlevel 3
  | Task          | Estim. |
  |---------------+--------|
  | * Development |   3:00 |
  | ** Task 1     |   1:00 |
  | ** Task 2     |   2:00 |
  | *** Task 2a   |   1:00 |
  | *** Task 2b   |   1:00 |
  #+END:

Though, this is hard to read for other people: they think, at first sight,
that the numbers must be added, while they already are summed up.

What I would like is a view like this one:

  #+BEGIN: clocktable :maxlevel 3 :scope file
  Clock summary at [2011-11-09 Wed 16:45]

  | Headline    | Time |      |      |
  |-------------+------+------+------|
  | Total time  | 4:00 |      |      |
  |-------------+------+------+------|
  | Development | 4:00 |      |      |
  | Task 1      |      | 1:00 |      |
  | Task 2      |      | 2:00 |      |
  | Task 2a     |      |      | 1:00 |
  | Task 2b     |      |      | 1:00 |
  #+END:

which we get with CLOCK lines:

#+begin_src org
  * Development
    :LOGBOOK:
    CLOCK: [2011-11-09 Wed 10:00]--[2011-11-09 Wed 11:00] =>  1:00
    :END:

  ** Task 1
     :LOGBOOK:
     CLOCK: [2011-11-09 Wed 11:00]--[2011-11-09 Wed 12:00] =>  1:00
     :END:

  ** Task 2

  *** Task 2a
      :LOGBOOK:
      CLOCK: [2011-11-09 Wed 12:00]--[2011-11-09 Wed 13:00] =>  1:00
      :END:

  *** Task 2b
      :LOGBOOK:
      CLOCK: [2011-11-09 Wed 13:00]--[2011-11-09 Wed 14:00] =>  1:00
      :END:
#+end_src

I don't think this is currently possible; but maybe some of you have found
workarounds, or developed something in this direction?

Best regards,
  Seb

-- 
Sebastien Vauban