From mboxrd@z Thu Jan  1 00:00:00 1970
From: dkrm <emacs.orgmode@dkrm.fastmail.com>
Subject: Total amount of efforts estimates per file
Date: Fri, 20 Mar 2020 10:20:38 +0100
Message-ID: <bcc73fce-949b-4f36-9479-4bd414bdd70f@www.fastmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org>
Received: from eggs.gnu.org ([2001:470:142:3::10]:52022)
 by lists.gnu.org with esmtp (Exim 4.90_1)
 (envelope-from <emacs.orgmode@dkrm.fastmail.com>) id 1jFDqf-0003gZ-VK
 for emacs-orgmode@gnu.org; Fri, 20 Mar 2020 05:21:51 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <emacs.orgmode@dkrm.fastmail.com>) id 1jFDqe-00066j-Qz
 for emacs-orgmode@gnu.org; Fri, 20 Mar 2020 05:21:49 -0400
Received: from wout1-smtp.messagingengine.com ([64.147.123.24]:46211)
 by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
 (Exim 4.71) (envelope-from <emacs.orgmode@dkrm.fastmail.com>)
 id 1jFDqe-00063q-6h
 for emacs-orgmode@gnu.org; Fri, 20 Mar 2020 05:21:48 -0400
Received: from compute7.internal (compute7.nyi.internal [10.202.2.47])
 by mailout.west.internal (Postfix) with ESMTP id 91FEA634
 for <emacs-orgmode@gnu.org>; Fri, 20 Mar 2020 05:21:45 -0400 (EDT)
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@gnu.org?subject=unsubscribe>
List-Archive: <https://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org
Sender: "Emacs-orgmode"
 <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org>
To: emacs-orgmode@gnu.org

Hi,

I have a per-project workflow, where each file is a project and every top headlines is a task in the project. At the beginning of a project I create the tasks for it and add an effort to each tasks. Then I want to have the sum of the efforts for the whole project. At this time there is no clocked time yet so, unfortunately, a clocktable doesn't work.

The closest that I could get was to create a 'columnview' dynamic block. With this Org file:

* NEXT task1
:PROPERTIES:
:Effort:   0:10
:END:
* NEXT task2
:PROPERTIES:
:EFFORT:   4:30
:END:
** NEXT subtask2-1
:PROPERTIES:
:Effort:   3:00
:END:
** NEXT subtask2-2
:PROPERTIES:
:Effort:   1:30
:END:
* NEXT task3
** NEXT subtask3-1
* NEXT task4

The columnview dynamic block produces this:

#+BEGIN: columnview :hlines 1 :id global :format "%50ITEM(Task) %Effort{:}"
| Task       | Effort |
|------------+--------|
| task1      |   0:10 |
|------------+--------|
| task2      |   4:30 |
| subtask2-1 |   3:00 |
| subtask2-2 |   1:30 |
|------------+--------|
| task3      |        |
| subtask3-1 |        |
|------------+--------|
| task4      |        |

But the efforts total is not calculated. Is there a way to get it?