From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Welle Subject: Re: "clocktable" for efforts Date: Fri, 09 Feb 2018 10:14:56 +0100 Message-ID: <87372afrsf.fsf@luisa.c0t0d0s0.de> References: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40672) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ek4lx-0004UR-QH for emacs-orgmode@gnu.org; Fri, 09 Feb 2018 04:15:10 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ek4lt-0003sv-Jd for emacs-orgmode@gnu.org; Fri, 09 Feb 2018 04:15:09 -0500 Received: from mout.gmx.net ([212.227.17.21]:52451) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1ek4lt-0003rV-8Q for emacs-orgmode@gnu.org; Fri, 09 Feb 2018 04:15:05 -0500 Received: from stella.c0t0d0s0.de ([89.204.155.246]) by mail.gmx.com (mrgmx101 [212.227.17.168]) with ESMTPSA (Nemesis) id 0MXDo1-1eDoXb0HXp-00WFbl for ; Fri, 09 Feb 2018 10:15:02 +0100 Received: from Stella (stella.c0t0d0s0.de [192.168.42.1]) by stella.c0t0d0s0.de (Postfix) with ESMTP id 35991C43AC for ; Fri, 9 Feb 2018 10:14:56 +0100 (CET) In-Reply-To: (Piotr Isajew's message of "Fri, 9 Feb 2018 05:53:57 +0000 (UTC)") 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 Hello, Piotr Isajew writes: > Hi, > > I wonder if it's possible to have something like a clocktable, but > based on effort, not the clocked time. My use case is that at the > beginning of the project, when the effort for each of tasks is > estimated, but none has been worked on yet, I need to generate > some reports (preferably with tag filters) to show the aggregated > effort for parts of the project. does this stripped-down example help? ########## #+LINK_UP: index.html #+LINK_HOME: ../index.html #+TITLE: BIRD #+COLUMNS: %50ITEM(Task) %Effort(Estimated){:} %CLOCKSUM(Clocked) %5TODO(State) * Effort #+BEGIN: columnview :hlines 2 :id "756fcb74-2e46-4757-82b8-461ed30a5f11" | Task | Estimated | Clocked | State | |-----------------------------------------------------+-----------+---------+-------| | User Stories | 54:00 | 1:24 | | |-----------------------------------------------------+-----------+---------+-------| | UI | 48 | 1:24 | DONE | | Remove Company, Street, Place, Country again | | 1:24 | DONE | |-----------------------------------------------------+-----------+---------+-------| | Check preconditions | 6 | | | | Check hw preconditions: hard disk, core memory, etc | | | DONE | #+END: * User Stories :PROPERTIES: :ID: 756fcb74-2e46-4757-82b8-461ed30a5f11 :END: ** DONE UI [11/11] :PROPERTIES: :Effort: 48 :END: The user wants to have a familiar UI. Should look like xxxx, etc. The user wants to be entertained within his or her monkey time. [2012-06-25 Mon] Extended: Show every parameter on its own page. *** DONE Remove Company, Street, Place, Country again - State "DONE" from "OPEN" [2012-07-17 Tue 09:51] - State "OPEN" from "TODO" [2012-07-17 Tue 08:27] CLOCK: [2012-07-17 Tue 08:27]--[2012-07-17 Tue 09:51] => 1:24 [2012-07-16 Mon] - Am [2012-07-16 Mon] so mit xx besprochen ** Check preconditions [4/4] :PROPERTIES: :Effort: 6 :END: The admin wants only certain user classes in certain circumstances to be allowed to trigger reinstallations. The admin wants the user to migrate only clients, that she is logged in into. If the reinstallation is not allowed, inform the user in an approbiate way and abort. - Check dispersion of load - Check user class (FF, XX, TT, etc) if allowed to reinstall - Check if computer is allowed for reinstall *** DONE Check hw preconditions: hard disk, core memory, etc - State "DONE" from "TODO" [2012-07-17 Tue 09:21] [2012-07-09 Mon] - Escript periodically retrieves values on client and sets computer property - user.ps1 check computer property ########## Regards hmw