Re: [O] how to group together fields

[Stefan Huchler]

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 <address@hidden> writes:

> Hi Stefan,
>
> (Hint: use `S W' from Gnus to reply to this email.)
>
> Stefan Huchler <address@hidden> 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!