From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Eric Schulte" Subject: Re: Saving column views in agenda Date: Thu, 11 Dec 2008 11:09:17 -0800 Message-ID: <877i664jhe.fsf@gmail.com> References: <06D0017E-5568-42C0-9AA2-4777F558D23E@uva.nl> <87k5aau0lh.fsf@fastmail.fm> <87ej0hypx4.fsf@fastmail.fm> <87vdtq67i0.fsf@gmail.com> <87y6ymirmv.fsf@fastmail.fm> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LAquV-0007gD-RS for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 14:09:19 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LAquV-0007fM-8l for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 14:09:19 -0500 Received: from [199.232.76.173] (port=57627 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LAquU-0007f5-Ml for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 14:09:18 -0500 Received: from wf-out-1314.google.com ([209.85.200.170]:4992) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LAquU-00054l-9I for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 14:09:18 -0500 Received: by wf-out-1314.google.com with SMTP id 28so804119wfc.24 for ; Thu, 11 Dec 2008 11:09:18 -0800 (PST) In-Reply-To: <87y6ymirmv.fsf@fastmail.fm> (Matthew Lundin's message of "Thu, 11 Dec 2008 10:49:28 -0600") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Matthew Lundin Cc: Org-mode Matthew Lundin writes: > Eric, > > Thanks so much. The updated org-collector works beautifully. This is a > very nice way to perform calculations on subsets of data. I don't > suppose there's any chance of generating a table that contains only > the items in the subset (e.g., only items in which string= spendtype > "food")? > Hi Matthew, Good idea. I've added a :conds parameter which can do just that, see the example below. Notice that :conds should be a list of tests, not just one single test, if this proves awkward it would be easy to add a :cond parameter which doesn't require a list. One issue with this setup, is that it's not clear what a stable way would be to specify the #+TBLFM line. Since the size of the table could vary the field in which the sum should be placed could move around. With the table below a #+TBLFM line like this #+TBLFM: @II+1$2=vsum(@I+1..@II-1) would work, but currently org-table does not allow the @I style references before the = sign in the table formula. I wonder if this would be hard difficult to change? Thanks -- Eric * Example #+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols (ITEM amount) | "ITEM" | "amount" | |----------------------------------+----------| | "Grocery Store [2008-12-01 Mon]" | 56.77 | | "Restaurant [2008-12-08 Mon]" | 30.67 | |----------------------------------+----------| | | 87.44 | #+TBLFM: @4$2=vsum(@I+1..@II-1) #+END: ** December Spending :PROPERTIES: :ID: december :END: *** Week One **** Grocery Store [2008-12-01 Mon] :PROPERTIES: :amount: 56.77 :spendtype: food :END: **** Athletic club [2008-12-02 Tue] :PROPERTIES: :amount: 75.00 :spendtype: health :END: *** Week Two **** Restaurant [2008-12-08 Mon] :PROPERTIES: :amount: 30.67 :spendtype: food :END: