emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Uwe Brauer <oub@mat.ucm.es>
To: emacs-orgmode@gnu.org
Subject: aggregate: percent, table headers, float format
Date: Thu, 28 Jun 2018 14:53:24 +0200	[thread overview]
Message-ID: <874lhn9inv.fsf@mat.ucm.es> (raw)


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: $1=@#-1


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 

next             reply	other threads:[~2018-06-28 12:53 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2018-06-28 12:53 Uwe Brauer [this message]
2018-06-28 17:36 ` aggregate: percent, table headers, float format Thierry Banel
2018-06-30  8:29   ` Uwe Brauer
2018-07-31 22:33 ` Thierry Banel

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=874lhn9inv.fsf@mat.ucm.es \
    --to=oub@mat.ucm.es \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).