From mboxrd@z Thu Jan 1 00:00:00 1970 From: Subhan Tindall Subject: How to get effort summary in clocktable in agenda? Date: Wed, 5 Feb 2014 17:21:08 -0800 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7bf0ef301de4b504f1b2b0e6 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59702) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WBDeT-0001eV-Le for emacs-orgmode@gnu.org; Wed, 05 Feb 2014 20:21:18 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WBDeO-0003Lh-WE for emacs-orgmode@gnu.org; Wed, 05 Feb 2014 20:21:13 -0500 Received: from mail-vb0-f51.google.com ([209.85.212.51]:52548) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WBDeO-0003LR-S8 for emacs-orgmode@gnu.org; Wed, 05 Feb 2014 20:21:08 -0500 Received: by mail-vb0-f51.google.com with SMTP id 11so940604vbe.10 for ; Wed, 05 Feb 2014 17:21:08 -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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Org-Mode --047d7bf0ef301de4b504f1b2b0e6 Content-Type: text/plain; charset=ISO-8859-1 Hi, i've got an agenda report that includes a clocktable that looks like this: | File | Effort | ALLTAGS | Headline | Time | |--------------+--------+---------+------------------------------------------+--------| | | ALL | | *Total time* | *8:24* | |--------------+--------+---------+------------------------------------------+--------| | Work-log.org | | | *File time* | *8:24* | | | | :514: | PPTDEV-514 Miscellaneous | 1:06 | | | | :514: | \__ W06 email, morning | 1:06 | | | | :513: | PPTDEV-513 smt 2014 Meetings | 0:17 | | | | :513: | \__ Standup | 0:17 | | | | | PPTDEV-318 HVE Industry - Feed runner... | 4:47 | | | 0:15 | | \__ SPEC redo spec with RDE | 1:39 | | | | | \__ TODO Modify... | 3:08 | | | | :389: | JWRK PPTDEV-389 VBA macros | 2:14 | | | | :389: | \__ Notes | 2:14 | What I'd really love to have is a column that shows the summarized Effort estimate for the top level headings. IE PPTDEV-318-HVE Industry has a time summary of 4:47 for the day, but only shows the the effort estimate for the individual subtasks that are displayed. If I increase the task level I can see more of the underlying structure, but not a summary. Is there a variable I'm missing here to set up my column as a summary? While I'm at it, is there an easy way to include a calculated column in the clock table (either in the agenda or one generated in my org file) that would show Effort - time for a given headline? Thanks! Subhan -- Subhan Michael Tindall | Software Developer | smt@rentrakmail.com RENTRAK | www.rentrak.com | NASDAQ: RENT --047d7bf0ef301de4b504f1b2b0e6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi, i've got an agenda report that includes a clocktab= le that looks like this:
| File =A0 =A0 =A0 =A0 | Effort | ALLTAGS= | Headline =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= | =A0 Time |
|--------------+--------+---------+----------------= --------------------------+--------|
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| ALL =A0 =A0| =A0 =A0 =A0 =A0 | *Total t= ime* =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | *8:24* |
|--------------+--------+---------+---------------------------------= ---------+--------|
| Work-log.org | =A0 =A0 =A0 =A0| =A0 =A0 =A0= =A0 | *File time* =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0| *8:24* |
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :514: =A0 | PPTDEV-514= Miscellaneous =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 1:06 |
| =A0= =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :514: =A0 | \__ W06 email, morni= ng =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 1:06 |
| =A0 =A0 =A0= =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :513: =A0 | PPTDEV-513 smt 2014 Meetings= =A0 =A0 =A0 =A0 =A0 =A0 | =A0 0:17 |
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :513: =A0 | \__ Standu= p =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 0:17 |
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 | = PPTDEV-318 HVE Industry - Feed runner... | =A0 4:47 |
| =A0 =A0 = =A0 =A0 =A0 =A0 =A0| 0:15 =A0 | =A0 =A0 =A0 =A0 | \__ SPEC redo spec with R= DE =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 1:39 |
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0 | \__ = TODO Modify... =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 3:08 |
| =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :389: =A0 | JWRK PPT= DEV-389 VBA macros =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 2:14 |
| =A0= =A0 =A0 =A0 =A0 =A0 =A0| =A0 =A0 =A0 =A0| :389: =A0 | \__ Notes =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0| =A0 2:14 |

What I'd really love to have is a column that shows= the summarized Effort estimate for the top level headings.
IE PP= TDEV-318-HVE Industry has a time summary of 4:47 for the day, but only show= s the the effort
estimate for the individual subtasks that are displayed. =A0If I incre= ase the task level I can see more of the underlying structure, but not a su= mmary.
Is there a variable I'm missing here to set up my colu= mn as a summary?
While I'm at it, is there an easy way to include a calculated colu= mn in the clock table (either in the agenda or one generated in my org file= ) that would show =A0Effort - time for a given headline?

Thanks!
Subhan


--
Subhan Michael Tindall | Software Developer
|= smt@rentrakmail.c= om
RENTRAK | www.rentrak= .com | NASDAQ: RENT
--047d7bf0ef301de4b504f1b2b0e6--