Done.
Now orgaggregate takes org-calc-default-modes
into account.
The priority is as follow:
- If given, a formatter modifier (like ;p17) takes
precedence.
- Otherwise, if a customization of org-calc-default-modes
is found (like calc-internal-prec set to 17),
then it applies.
To customize, type M-x customize-variable
org-calc-default-modes RET.
- Ultimately, the Calc customization (like (setq
calc-internal-prec 17)) is used.
The upgrade will take some time (a few hours maybe) to show up in
the Melpa Emacs packages repository.
Thanks Uwe for reporting.
Regards
Thierry
On 28/06/2018 14:53, Uwe Brauer wrote:
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
|
