From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms1.migadu.com with LMTPS id GJX7BvtcFGaiZAEAe85BDQ:P1 (envelope-from ) for ; Mon, 08 Apr 2024 23:09:15 +0200 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2.migadu.com with LMTPS id GJX7BvtcFGaiZAEAe85BDQ (envelope-from ) for ; Mon, 08 Apr 2024 23:09:15 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1712610554; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=pwRE6wfOzGFSPvLrldTTJXAoXGTrzpEfsdLEPPqLnQ4=; b=TweCJm8Sep0GoUuNEtJaWnkGnFR6YXD4Ws14ahDeMdeh8xkRTE7N1vDr8kaYGip+O+vuKe Zwp6cp8taPkVRm/627mI+POaW1pSSiR99TVBgVAQzYPK8osB0K4Agc9R4kHim7cyc/DPST G87ooiIrz3mwaqNv6Wt5hZVZraJKy15guv0fpPhiUsJJWzexizACgtLERHN0wx0edK42B8 hqVQ9y6OSjm4AE6hWjqq+LjL07/1mDX1AHymPzoic3ULqZ77Btn0ZHvQAWH8+DCvNRH8Mc FFOx3CZOY97lyEfGVJPh1rqF6RcXyq+Ej9e5fAipi7xOrYI/iX0zADFCYbO41g== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1712610554; a=rsa-sha256; cv=none; b=DdG+O7jxOeozm2MYL9JZBKtc0V7lN7xFzJbih25nVA3k3R7IM9e9iHFT0AgZqETh67gVqk CKQigsMgsaBaIuquUGOSLVKg3u5Nq56g5Ltr1h5uV3TcmlOnhfWRcoNdjc4otHg1irby3J 5B+wznXn7GP5zLblV74uKmANwjfOgKR6uaTtq2W5CXHdLe2HszvEqSqr3vcPWdDbnn54ss E1GqPVpT+fPc7AkiBrUkj9W5Ei601APWzMRuZ494dbDJUyMTp5b9LpZZrKX98xqbSOdItH aXeLb8oaMfZpsQD3c4LSty/QdvAsfBm3P6b3hnEqqQq0wXdOJYR66tY6x+dIVA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=none Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id DE7DF15A0B for ; Mon, 8 Apr 2024 23:09:14 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rtwE9-00008a-0m; Mon, 08 Apr 2024 17:08:29 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rtwE5-000067-56 for emacs-orgmode@gnu.org; Mon, 08 Apr 2024 17:08:26 -0400 Received: from smtprelay07.ispgateway.de ([134.119.228.103]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rtwE0-0002cq-WB for emacs-orgmode@gnu.org; Mon, 08 Apr 2024 17:08:24 -0400 Received: from [185.17.206.89] (helo=condition-alpha.com) by smtprelay07.ispgateway.de with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.97.1) (envelope-from ) id 1rtwDv-000000002fV-2IOp for emacs-orgmode@gnu.org; Mon, 08 Apr 2024 23:08:15 +0200 Message-Id: <486d2b818b62c71b3f307305c06c4318@condition-alpha.com> From: Alexander Adolf To: emacs-orgmode@gnu.org Subject: columnview dynamic block - different time summing behaviour for EFFORT and CLOCKSUM Date: Mon, 08 Apr 2024 23:08:15 +0200 MIME-Version: 1.0 Content-Type: text/plain X-Df-Sender: YWxleGFuZGVyLmFkb2xmQGNvbmRpdGlvbi1hbHBoYS5jb20= Received-SPF: pass client-ip=134.119.228.103; envelope-from=alexander.adolf@condition-alpha.com; helo=smtprelay07.ispgateway.de X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: -6.37 X-Spam-Score: -6.37 X-Migadu-Queue-Id: DE7DF15A0B X-Migadu-Scanner: mx12.migadu.com X-TUID: PWo39yjWzxpK Hello Org experts, it seems that the time summing behaviour of columnview dynamic blocks is different for CLOCKSUM than for EFFORT columns with respect to how the contributions from sub-headlines are handled. When summing up CLOCKSUM columns, a parent headline can have its own clocked time, which gets added to the sum of its sub-items' clocked times to produce its CLOCKSUM value. When summing up EFFORT columns, any effort a parent headline may have been manually assigned gets overwritten with the sum of its sub-items' efforts, however. In the example at the end of this message, compare the results for tasks A and D. If you change the effort for either task B or C, and then update the dynamic block, the EFFORT in the property drawer of task A will get overwritten with the new sum of B's and C's efforts. I'd have two questions regarding this: Does anyone recall the rationale for this different behaviour? Is there any way to change the summation behaviour for either or both column types? I have no preference for either behaviour; they both will have their merits and applications, depending on how one organises things. I do think that being able to get the same behaviour would seem advantageous, however. Many thanks and looking forward to your thoughts, --alexander ---------------------------- Begin Quote ----------------------------- * Example Project #+BEGIN: columnview :maxlevel 4 :skip-empty-rows t :indent t :format "%70ITEM(Task) %17Effort(Estimated){:} %17CLOCKSUM(Clocked){:}" :id local | Task | Estimated | Clocked | |-----------------+-----------+----------| | Example Project | 6d 0:00 | 15d 0:00 | | \_ Task A | 3d 0:00 | 9d 0:00 | | \_ Task B | 1d | 3d 0:00 | | \_ Task C | 2d | 3d 0:00 | | \_ Task D | 3d 0:00 | 6d 0:00 | | \_ Task E | 1d | 3d 0:00 | | \_ Task F | 2d | 3d 0:00 | #+END: ** Task A :PROPERTIES: :EFFORT: 3d 0:00 :END: :LOGBOOK: CLOCK: [2023-12-08 Fri 15:51 +0100]--[2023-12-09 Sat 01:50 +0100] => 9:59 CLOCK: [2022-01-07 Fri 18:35 +0100]--[2022-01-08 Sat 08:36 +0100] => 14:10 :END: *** Task B :PROPERTIES: :Effort: 1d :END: :LOGBOOK: CLOCK: [2023-12-08 Fri 15:51 +0100]--[2023-12-09 Sat 01:50 +0100] => 9:59 CLOCK: [2022-01-07 Fri 18:35 +0100]--[2022-01-08 Sat 08:36 +0100] => 14:10 :END: *** Task C :PROPERTIES: :Effort: 2d :END: :LOGBOOK: CLOCK: [2023-12-08 Fri 15:51 +0100]--[2023-12-09 Sat 01:50 +0100] => 9:59 CLOCK: [2022-01-07 Fri 18:35 +0100]--[2022-01-08 Sat 08:36 +0100] => 14:10 :END: ** Task D *** Task E :PROPERTIES: :Effort: 1d :END: :LOGBOOK: CLOCK: [2023-12-08 Fri 15:51 +0100]--[2023-12-09 Sat 01:50 +0100] => 9:59 CLOCK: [2022-01-07 Fri 18:35 +0100]--[2022-01-08 Sat 08:36 +0100] => 14:10 :END: *** Task F :PROPERTIES: :Effort: 2d :END: :LOGBOOK: CLOCK: [2023-12-08 Fri 15:51 +0100]--[2023-12-09 Sat 01:50 +0100] => 9:59 CLOCK: [2022-01-07 Fri 18:35 +0100]--[2022-01-08 Sat 08:36 +0100] => 14:10 :END: ----------------------------- End Quote ------------------------------