emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] aggregate: percent, table headers, float format


From: Uwe Brauer
Subject: [O] aggregate: percent, table headers, float format
Date: Thu, 28 Jun 2018 14:53:24 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/27.0.50 (gnu/linux)

Hi

Org-aggregate is great and very helpful.

However I have some problems/questions which I think a maybe interesting
for the list.

Take the following code


#+begin_src emacs-lisp
(setq org-calc-default-modes '(calc-internal-prec 12 calc-float-format
                    (fix 3)    ;;; the default here was (float 8)
                    calc-angle-mode deg calc-prefer-frac nil calc-symbolic-mode 
nil calc-date-format
                    (YYYY "-" MM "-" DD " " Www
                          (" " hh ":" mm))
                    calc-display-working-message t))

#+end_src

Which sets the float format to (fix 3) is taken into account by the
org-table but ignored by org aggregate as the example below shows.


#+TBLNAME: raw-data
| Number | CalJunio |
|--------+----------|
|      1 | AP       |
|      2 | NT       |
|      3 | SS       |
|      4 | SS       |
|      5 | SS       |
|      6 | AP       |
|      7 | SS       |
|      8 | NP       |
|      9 | AP       |
|     10 | NP       |
|     11 | NP       |
|     12 | AP       |
|     13 | NP       |
|     14 | AP       |
|     15 | NP       |
|     16 | AP       |
|     17 | SS       |
|     18 | NP       |
|     19 | AP       |
#+TBLFM: address@hidden


I want that org aggregate counts the entries in the second column of the
tale raw-data, which it does (thanks to Thierry), but I also would like
to have, automatically, to calculate its percentage. And that it seems I
can only do manually as the below example shows.

#+BEGIN: aggregate :table "raw-data" :cols "CalJunio count()  (count()/19)*100"
| CalJunio | count() | (count()/19)*100 |
|----------+---------+------------------|
| AP       |       7 |    36.8421052632 |
| NT       |       1 |    5.26315789474 |
| SS       |       5 |    26.3157894737 |
| NP       |       6 |    31.5789473684 |
#+END:


Is there a more elegant solution and how can I change the float format?

By the way is there a way to customize the header of the above table,
something like


#+BEGIN: aggregate :table "raw-data" :cols "CalJunio count()  (count()/19)*100"
| CalJunio | count |       percent |
|----------+-------+---------------|
| AP       |     7 | 36.8421052632 |
| NT       |     1 | 5.26315789474 |
| SS       |     5 | 26.3157894737 |
| NP       |     6 | 31.5789473684 |
#+END:


thanks

Uwe Brauer 




reply via email to

[Prev in Thread] Current Thread [Next in Thread]