[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Saving column views in agenda
From: |
mdl |
Subject: |
Re: [Orgmode] Saving column views in agenda |
Date: |
Mon, 08 Dec 2008 09:51:22 -0600 |
User-agent: |
Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) |
Hi Carsten,
Carsten Dominik <address@hidden> writes:
> Hi Matthew,
>
> this is currently not possible.
>
> You could try to use the mapping API to do something yourself.
>
> What is your use-case?
>
> - Carsten
Thanks for the quick response. I use the agenda to filter column views
via property searches. Let's say I'm keeping track of my spending with
the following outline:
#+COLUMNS: %20ITEM %10TIMESTAMP %20spendtype %10amount{$}
* December Spending
** Week One
*** Grocery Store [2008-12-01 Mon]
:PROPERTIES:
:amount: 56.77
:spendtype: food:
:END:
*** Athletic club [2008-12-02 Tue]
:PROPERTIES:
:amount: 75.00
:spendtype: health
:END:
** Week Two
*** Restaurant [2008-12-08 Mon]
:PROPERTIES:
:amount: 30.67
:spendtype: food
:END:
With such an outline (obviously much longer and more complex in
reality), I use columns and dynamic blocks to give me a quick overview
(with sums) of spending by week. I also use the agenda to filter these
views by spendtype, so that I can see, for instance, the sum of how
much I spent on food each week/month/year. Currently, I can use column
view in the agenda to generate sums, but I cannot export the column
view for permanent reference or for sharing with others.
I suppose this functionality could be achieved in a few other ways as
well:
1) A dynamic block that captures a column view, but with a parameter
that filters for TAG, property, etc.
2) A column view combined with a sparse tree that sums the amounts of
only the visible items. Currently, when "summary-type" is specified,
the column view adds all items in the outline hierarchy, regardless of
their visibility. (Of course, if this method were possible, one would
still have to devise a way to export the filtered column view.)
3) A filter for tables that one could apply to the exported column
view. (E.g., show only rows in which "Column 3 = x" and calculate only
the visible items.)
There is, of course, the likelihood that #1, #2, or #3 already exist
and that I have simply missed something in the manual. Please do let
me know if this is the case. I also realize that I could simply
create subheadings for each spending type (e.g., *** Food) that would
create the desired effect in the column view. But as data becomes more
complex, it would be nice to generate these filtered views
dynamically.
To sum up a long reply: I am curious whether it is possible to create
exportable, dynamically filtered data in column views, in which the
sum created in a "summary-type" column is recalculated when items are
filtered. (I suppose this would count as part of org-mode's
"spreadsheet" functionality.)
Thanks, as always, for such a wonderful program.
Matt
>
> On Dec 8, 2008, at 6:52 AM, Matthew Lundin wrote:
>
>>
>> I often use dynamic blocks to save/export column views in org-mode
>> files. Does anyone know of a similar way to export/save a column view
>> from the agenda? When I write the agenda to a file, it naturally
>> writes only the text (not the column overlay).
>>
>> Regards,
>> Matt
>>
>>
>> _______________________________________________
>> Emacs-orgmode mailing list
>> Remember: use `Reply All' to send replies to the list.
>> address@hidden
>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- [Orgmode] Saving column views in agenda, Matthew Lundin, 2008/12/08
- Re: [Orgmode] Saving column views in agenda, Carsten Dominik, 2008/12/08
- Re: [Orgmode] Saving column views in agenda,
mdl <=
- Re: [Orgmode] Saving column views in agenda, Carsten Dominik, 2008/12/09
- Re: [Orgmode] Saving column views in agenda, Matthew Lundin, 2008/12/09
- Re: [Orgmode] Saving column views in agenda, Eric Schulte, 2008/12/11
- Message not available
- Re: [Orgmode] Saving column views in agenda, Eric Schulte, 2008/12/11
- Re: [Orgmode] Saving column views in agenda, mdl, 2008/12/11
- Re: [Orgmode] Saving column views in agenda, Carsten Dominik, 2008/12/12
- Re: [Orgmode] Saving column views in agenda, Matthew Lundin, 2008/12/12
- Re: [Orgmode] Saving column views in agenda, Carsten Dominik, 2008/12/12
- Re: [Orgmode] Saving column views in agenda, Carsten Dominik, 2008/12/12
- Re: [Orgmode] Saving column views in agenda, Matthew Lundin, 2008/12/11