"clocktable" for efforts

"clocktable" for efforts

[Piotr Isajew]

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.

I've been trying:

- column view, which can show items with effort estimates even
  though there's no time clocked for them (but it doesn't seem to
  support tag filters when summing up efforts).
- clocktable, which supports tag filters, but doesn't show items,
  for which there's only effort estimate (i.e. no time has been
  clocked).

Bests,

Piotr

Re: "clocktable" for efforts

[Michael Welle]

Hello,

Piotr Isajew <pki@ex.com.pl> 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

Re: "clocktable" for efforts

[Piotr Isajew]

Dnia 09.02.2018 Michael Welle <mwe012008@gmx.net> napisał/a:
> Hello,
>
> Piotr Isajew <pki@ex.com.pl> 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?
[..]
> * Effort
> #+BEGIN: columnview :hlines 2 :id "756fcb74-2e46-4757-82b8-461ed30a5f11"

Yes, it does. I still have to solve the issue of setting tag
filters, but you helped a lot. Thank you :)