From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stefan Huchler Subject: Re: how to group together fields Date: Mon, 03 Feb 2014 16:25:44 +0100 Message-ID: <8738k09q13.fsf@mars.lan> References: <87fvo5tqvo.fsf@mars.lan> <87fvo4bcjw.fsf@gmail.com> <87r47nshuh.fsf@mars.lan> <87bnyrayda.fsf@gmail.com> <87ioszrr6l.fsf@mars.lan> <87wqhf9fmy.fsf@gmail.com> <87d2j7rno9.fsf@mars.lan> <87txcgy3ya.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60268) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WALPK-0002RA-0Y for emacs-orgmode@gnu.org; Mon, 03 Feb 2014 10:26:02 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WALPF-0008RZ-MY for emacs-orgmode@gnu.org; Mon, 03 Feb 2014 10:25:57 -0500 In-Reply-To: <87txcgy3ya.fsf@bzg.ath.cx> (Bastien's message of "Mon, 03 Feb 2014 09:51:09 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Bastien Cc: emacs-orgmode@gnu.org Hi Bastien, I want to extract Information with ColumnView from a org-tree, that works like group-by in a select statement. so if I have a tree like that: * Tea Database :PROPERTIES: :COLUMNS: %Shop(Shop) %rating(Rating){mean} :END: ** Tea Shop 1 :PROPERTIES: :Shop: Tea Shop 1 :END: *** Order 1 :PROPERTIES: :END: **** Tee 1 :PROPERTIES: :blend: Pussimbing :rating: 1 :END: *** Order 2 :PROPERTIES: :END: **** Tea 1 :PROPERTIES: :blend: Pussimbing :rating: 5 :END: **** Tea 2 :PROPERTIES: :blend: Steinthal :rating: 7 :END: ** Tea Shop 2 :PROPERTIES: :Shop: Tea Shop 2 :END: *** Tea 1 :PROPERTIES: :blend: Pussimbing :rating: 6 :END: *** Tea 2 :PROPERTIES: :blend: Steinthal :rating: 8 :END: that works so far, I can see a list of shops and there mean ratings. I want now as another "table" a second columns line what I would comment out with the current :COLUMNS: line that would look like that: :COLUMNS: %blend(Blend){groupby blend} %rating(Rating){mean} I get with the 1. COLUMNS line something like that: Tea Shop 1 | 5.0 | ... Tea Shop 2 | 7.0 | ... I want another output that looks like that: Blend 1 | 6.0 | ... Blend 2 | 3.0 | ... btw blend is the wrong word, in this case it would be the origin tea garden, but thats only a context detail ;) The idea is that I give in data and a score for the tea, and I can look than which tea blends I liked most and which shop gave me best quality. hope its clear now ;) Bastien writes: > Hi Stefan, > > (Hint: use `S W' from Gnus to reply to this email.) > > Stefan Huchler writes: > >> If Bastien could look over it, it would be nice. > > The thread is a bit difficult to read -- can you make a summary > of what is the bug report or the feature request? > > Thanks!