Bug in clocktable report with formula %

Bug in clocktable report with formula %

[Andreas Mueller]

[-- Attachment #1: Type: text/plain, Size: 352 bytes --]

Hello

I think I may have found a bug in the clocktable report: When using
:formula %, it seems days are ignored in time percentage calculation.

I have attached a simple test.org which demonstrates this.

Emacs version: 24.5.1
Org version: Org mode version 9.0.2 (9.0.2-10-g820d1e-elpa @ ~/.emacs.d/elpa/org-20161223/)

Thanks & best regards,
Andreas

[-- Attachment #2: test.org --]
[-- Type: application/vnd.lotus-organizer, Size: 579 bytes --]

Re: Bug in clocktable report with formula %

[Nicolas Goaziou]

Hello,

Andreas Mueller <lists@0x7.ch> writes:

> I think I may have found a bug in the clocktable report: When using
> :formula %, it seems days are ignored in time percentage calculation.
>
> I have attached a simple test.org which demonstrates this.
>
> Emacs version: 24.5.1
> Org version: Org mode version 9.0.2 (9.0.2-10-g820d1e-elpa @ ~/.emacs.d/elpa/org-20161223/)
>
> Thanks & best regards,
> Andreas
>
> * Foo
>   CLOCK: [2016-12-27 Wed 13:09]--[2016-12-28 Wed 15:09] => 26:00
> * Bar
>   CLOCK: [2016-12-28 Wed 13:09]--[2016-12-28 Wed 15:09] =>  2:00
>
> * Report
> #+BEGIN: clocktable :maxlevel 2 :scope file :formula %
> #+CAPTION: Clock summary at [2016-12-28 Wed 15:10]
> | Headline     | Time      |   |     % |
> |--------------+-----------+---+-------|
> | *Total time* | *1d 4:00* |   | 100.0 |
> |--------------+-----------+---+-------|
> | Foo          | 1d 2:00   |   |  50.0 |
> | Bar          | 2:00      |   |  50.0 |
> #+TBLFM: $4='(org-clock-time% @2$2 $2..$3);%.1f
> #+END:

Fixed. Thank you.

Regards,

-- 
Nicolas Goaziou

Re: Bug in clocktable report with formula %

[Andreas Mueller]

[-- Attachment #1.1: Type: text/plain, Size: 1593 bytes --]

Hello

I just noticed with updated org (org-20170124), although days are no
longer ignored, the percentage calculation is still wrong.

It looks to me like the problem is that org-effort-durations calculates
minutes in a day with 8 hours per day (I assume the idea was to only
plan for 8 hour workdays).

Changing org-effort-durations to calculate with 24 hour days gives the
correct result of 93% / 7%.

Thanks & best regards,
Andreas


Nicolas Goaziou wrote:
> Hello,
> 
> Andreas Mueller <lists@0x7.ch> writes:
> 
>> I think I may have found a bug in the clocktable report: When using
>> :formula %, it seems days are ignored in time percentage calculation.
>>
>> I have attached a simple test.org which demonstrates this.
>>
>> Emacs version: 24.5.1
>> Org version: Org mode version 9.0.2 (9.0.2-10-g820d1e-elpa @ ~/.emacs.d/elpa/org-20161223/)
>>
>> Thanks & best regards,
>> Andreas
>>
>> * Foo
>>   CLOCK: [2016-12-27 Wed 13:09]--[2016-12-28 Wed 15:09] => 26:00
>> * Bar
>>   CLOCK: [2016-12-28 Wed 13:09]--[2016-12-28 Wed 15:09] =>  2:00
>>
>> * Report
>> #+BEGIN: clocktable :maxlevel 2 :scope file :formula %
>> #+CAPTION: Clock summary at [2016-12-28 Wed 15:10]
>> | Headline     | Time      |   |     % |
>> |--------------+-----------+---+-------|
>> | *Total time* | *1d 4:00* |   | 100.0 |
>> |--------------+-----------+---+-------|
>> | Foo          | 1d 2:00   |   |  50.0 |
>> | Bar          | 2:00      |   |  50.0 |
>> #+TBLFM: $4='(org-clock-time% @2$2 $2..$3);%.1f
>> #+END:
> 
> Fixed. Thank you.
> 
> Regards,
> 


[-- Attachment #1.2: test.org --]
[-- Type: application/vnd.lotus-organizer, Size: 575 bytes --]

[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 163 bytes --]

Re: Bug in clocktable report with formula %

[Nicolas Goaziou]

Hello,

Andreas Mueller <lists@0x7.ch> writes:

> I just noticed with updated org (org-20170124), although days are no
> longer ignored, the percentage calculation is still wrong.
>
> It looks to me like the problem is that org-effort-durations calculates
> minutes in a day with 8 hours per day (I assume the idea was to only
> plan for 8 hour workdays).
>
> Changing org-effort-durations to calculate with 24 hour days gives the
> correct result of 93% / 7%.

Fixed. Thank you.

Regards,

-- 
Nicolas Goaziou