emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Flávio <flaviostz@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Column Properties
Date: Tue, 3 Feb 2009 10:50:13 +0000 (UTC)	[thread overview]
Message-ID: <loom.20090203T101944-400@post.gmane.org> (raw)

I am using COLUMN VIEW to see a summary of worked and estimated hours. 
But I am
getting some strange results. 

In one big org file I clocked all my work in different atomic tasks 
(The file is mixed with English and Portuguese ). 
For example:

* Apontamento de Horas Gerais
** Atendimentos / Serviços
*** Estudo Técnico (externo)
*** Suporte Técnico
    :CLOCK:
     CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] =>  5:00
     CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] =>  0:41
     CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] =>  0:37
     CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] =>  0:30
    :END:
****  My Customer
***** Motor and valves problem ( go down )
      :CLOCK:
       CLOCK: [2008-12-01 Mon 13:00]--[2008-12-01 Mon 15:24] =>  2:23
       CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] =>  0:12
      :END:
***** 09.00698 - Technical Support 
      CLOCK: [2009-02-02 Mon 15:15]--[2009-02-02 Mon 16:56] =>  1:41

Then I decided to start with PROPERTIES for item "09.00698 - Technical Support",
and my file became:

* Apontamento de Horas Gerais
  :PROPERTIES:
  :COLUMNS:  %50ITEM  %10CLOCKSUM(Clocked) %5Effort(Estimate){:}
%5HourSold(Sold){:} 
  :ID:       apontamento_horas
  :END:
** Atendimentos / Serviços
*** Estudo Técnico (externo)
   
*** Suporte Técnico
    :CLOCK:
    CLOCK: [2008-11-25 Tue 14:30]--[2008-11-25 Tue 19:30] =>  5:00
    CLOCK: [2008-11-24 Mon 13:58]--[2008-11-24 Mon 14:39] =>  0:41
    CLOCK: [2008-11-24 Mon 13:11]--[2008-11-24 Mon 13:48] =>  0:37
    CLOCK: [2008-11-24 Mon 07:00]--[2008-11-24 Mon 07:30] =>  0:30
    :END:
**** My Customer
***** Motor and valves problem ( go down )
      :CLOCK:
      CLOCK: [2008-12-01 Mon 13:00]--[2008-12-01 Mon 15:24] =>  2:23
    CLOCK: [2008-11-26 Wed 15:28]--[2008-11-26 Wed 15:40] =>  0:12
    :END:
***** 09.00698 - Technical Support 
    :PROPERTIES:
    :Effort:   20:00
    :HourSold: 21:00
    :END:
     CLOCK: [2009-02-02 Mon 15:15]--[2009-02-02 Mon 16:56] =>  1:41

Then I generate a table using the code:

#+BEGIN: columnview :hlines 2 :vlines t :id "apontamento_horas" 
:skip-empty-rows t

#+END:

The code works fine and my table is ok, but I have some errors when:

1) If I want my CLOCKED column to be the last one and Estimate at first column,
all clocked values are filled in the first column anyway, although it is
Estimate. So the solution for this problem was to consider the CLOCKED always 
as the first column.

2) If I consider both Effort and HourSold Properties with the value of 20:00
under item "09.00698 - Technical Support", I get an empty column under Sold in
the summary table. So the solution for this problem was to consider the Effort
20:00 and Sold 21:00 then I get the correct summary.

I am using org-mode 6.12b and emacs 22.2.1. Is it a real problem or I am doing
anything wrong?

Regards,

Flávio.

             reply	other threads:[~2009-02-03 10:50 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-02-03 10:50 Flávio [this message]
2009-02-06 15:25 ` Carsten Dominik
2009-02-03 11:42 Giovanni Ridolfi

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=loom.20090203T101944-400@post.gmane.org \
    --to=flaviostz@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --subject='Re: Column Properties' \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this inbox:

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).