* org-aggregateの使用例
** 元の表
#+TBLNAME: original
| Day       | Color | Level | Quantity |
|-----------+-------+-------+----------|
| Monday    | Red   |    30 |       11 |
| Monday    | Blue  |    25 |        3 |
| Thuesday  | Red   |    51 |       12 |
| Thuesday  | Red   |    45 |       15 |
| Thuesday  | Blue  |    33 |       18 |
| Wednesday | Red   |    27 |       23 |
| Wednesday | Blue  |    12 |       16 |
| Wednesday | Blue  |    15 |       15 |
| Turdsday  | Red   |    39 |       24 |
| Turdsday  | Red   |    41 |       29 |
| Turdsday  | Red   |    49 |       30 |
| Friday    | Blue  |     7 |        5 |
| Friday    | Blue  |     6 |        8 |
| Friday    | Blue  |    11 |        9 |
** 曜日別のLevelの平均とQuantityの合計
#+BEGIN: aggregate :table "original" :cols "Day mean(Level) sum(Quantity)"
| Day       | mean(Level) | sum(Quantity) |
|-----------+-------------+---------------|
| Monday    |        27.5 |            14 |
| Thuesday  |          43 |            45 |
| Wednesday |          18 |            54 |
| Turdsday  |          43 |            83 |
| Friday    |           8 |            22 |
#+END:
** 項目数・合計・最小値・最大値・中央値
#+BEGIN: aggregate :table "original" :cols "count() sum(Quantity)"
| count() | sum(Quantity) |
|---------+---------------|
|      14 |           218 |
#+END:

#+BEGIN: aggregate :table "original" :cols "min(Level) max(Quantity) median(Level)"
| min(Level) | max(Quantity) | median(Level) |
|------------+---------------+---------------|
|          6 |            30 |          28.5 |
#+END:


** DayとColorが同じ項目を数える
#+BEGIN: aggregate :table "original" :cols "count() Day Color"
| count() | Day       | Color |
|---------+-----------+-------|
|       1 | Monday    | Red   |
|       1 | Monday    | Blue  |
|       2 | Thuesday  | Red   |
|       1 | Thuesday  | Blue  |
|       1 | Wednesday | Red   |
|       2 | Wednesday | Blue  |
|       3 | Turdsday  | Red   |
|       3 | Friday    | Blue  |
#+END:
** Red/Blueそれぞれの平均と合計
#+BEGIN: aggregate :table "original" :cols "Color  mean(Level) sum(Quantity)"
| Color |   mean(Level) | sum(Quantity) |
|-------+---------------+---------------|
| Red   | 40.2857142857 |           144 |
| Blue  | 15.5714285714 |            74 |
#+END: