[emacs-berlin] July 2025 Meetup is next week

[Tilmann Singer]

Hi again,

The maintainer of orgtbl-aggregate was kind enough to add a new feature
to support this use case. With the new argument :precompute, one or more
virtual columns with precomputed values can now be added to the table
before the aggregation occurs. The example from above can now be solved
like this:

#+name: distances
| Date             |   KM |
|------------------+------|
| [2025-07-16 Wed] | 28.6 |
| [2025-07-17 Thu] |    6 |
| [2025-07-18 Fri] |   12 |
| [2025-07-19 Sat] |   18 |
| [2025-07-20 Sun] |   18 |
| [2025-07-21 Mon] |   10 |
| [2025-07-22 Tue] |   14 |
| [2025-07-23 Wed] |    9 |
| [2025-08-01 Fri] |   12 |
| [2025-08-02 Sat] |   12 |
| [2025-08-03 Sun] |    9 |

#+BEGIN: aggregate :table "distances" :precompute "month(Date);'Month'" :cols "Month vsum(KM)"
| Month | vsum(KM) |
|-------+----------|
|     7 |    115.6 |
|     8 |       33 |
#+END:

Already availabe in melpa.


cheers, Til
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 853 bytes
Desc: not available
URL: <http://mailb.org/pipermail/emacs-berlin/attachments/20250810/38c853f6/attachment.sig>