I want to use org-mode as a (tea) database.
What have I done:
1. I have wrote down a tree of shops/orders/brands
2. I defined COLUMNS for Column View that give me a score per shop list
What do I want as result:
1. give me a list of scores for the shops [DONE]
2. give me a list of scores for each brand [TODO]
is there a way to group together Tea brands to give each Brand a Score
(how I liked it)?
below are the data I used (the scores are just random test-data):
(sorry the field names are german mostly)
* Tea Database
:PROPERTIES:
:COLUMNS: %Shop(Shop) %Bewertung(Bewertung){mean}
:END:
** Tee Kampagne
:PROPERTIES:
:Shop: Tee Kampagne
:END:
*** Bestellung 1
:PROPERTIES:
:END:
**** Tee 1
:PROPERTIES:
:Sorte: Pussimbing
:Bewertung: 1
:END:
*** Bestellung 2
:PROPERTIES:
:END:
**** Tee 1
:PROPERTIES:
:Sorte: Pussimbing
:Bewertung: 5
:END:
**** Tee 2
:PROPERTIES:
:Sorte: Steinthal
:Bewertung: 7
:END:
** Teeblätter Versand
:PROPERTIES:
:Shop: Teeblätter Versand
:END:
*** Tee 1
:PROPERTIES:
:Sorte: Pussimbing
:Bewertung: 6
:END:
*** Tee 2
:PROPERTIES:
:Sorte: Steinthal
:Bewertung: 8
:END:
*** Tee 3
:PROPERTIES:
:Sorte: Risheehat
:Bewertung: 9
:END:
