You may want to consider a slightly different approach. It may (or maynot) be relevant depending on your context.
First, denormalize your table into a "fact table" (which is handy when dealingwith cubes): #+name: data | date | type | q | |------------------+-------+-----| | [2014-04-27 Sun] | Sys | 125 | | [2014-04-28 Mon] | Sys | 102 | | [2014-04-29 Tue] | Sys | 115 | | [2014-04-27 Sun] | Dia | 88 | | [2014-04-28 Mon] | Dia | 88 | | [2014-04-29 Tue] | Dia | 88 | | [2014-04-27 Sun] | Pul | 78 | | [2014-04-28 Mon] | Pul | 86 | | [2014-04-29 Tue] | Pul | 85 | | [2014-04-27 Sun] | Sugar | 92 | | [2014-04-28 Mon] | Sugar | 92 | | [2014-04-29 Tue] | Sugar | 95 | Then using a package named "org-aggregate" (on Melpa) you can derivean aggregated table: #+name: aggr #+BEGIN: aggregate :table data :cols "type vcount() vmean(q) vmax(q) vsdev(q);f3" | type | vcount() | vmean(q) | vmax(q) | vsdev(q);f3 | |-------+----------+----------+---------+-------------| | Sys | 3 | 114 | 125 | 11.533 | | Dia | 3 | 88 | 88 | 0 | | Pul | 3 | 83 | 86 | 4.359 | | Sugar | 3 | 93 | 95 | 1.732 | #+END: If you want to rotate this table, apply a transposition on it(provided by the same package): #+BEGIN: transpose :table "aggr" | type | | Sys | Dia | Pul | Sugar | | vcount() | | 3 | 3 | 3 | 3 | | vmean(q) | | 114 | 88 | 83 | 93 | | vmax(q) | | 125 | 88 | 86 | 95 | | vsdev(q);f3 | | 11.533 | 0 | 4.359 | 1.732 | #+END: You can sort the "data" table on dates without changing theaggregation. Thierry Le 02/06/2015 13:44, Jude DaShiell a écrit : > | Date | Sys | Dia | Pul | Sugar | > |------------------+-------------------+-----+-----+-------| > | [2014-04-27 Sun] | 125 | 88 | 78 | 92 | > | [2014-04-28 Mon] | 102 | 88 | 86 | 92 | > | Averages: | =$2=vmean(@<..@>) | | | | > #+TBLFM: $2=$2=vmean(@<..@>) > > This is a cut down version of my full record set. Sometimes when I > key formulas in I get ?ERROR back for a result after keying in c-c+c-c > once I've completed the formula and hit tab. If I do c-u+c-c+c-c that > sometimes generated ?ERROR. Other times I key in a formula and the > cursor gets locked and I have to hit c-g to exit #+TBLFM: mode; I > don't know what's actually happening when that situation arises since > other than suddenly finding the cursor locked I can neither tell what > state I'm in or if a few more keystrokes are needed or if I've > generated an error situation. > > -- > > >
