How can you sort an Org clock table?

How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 399 bytes --]

I posted a question on StackOverflow:

http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table

Summary is: how do I sort an clock table by the % column?

Is there anything "out there" I can use to get this working? If not, how
complex a job would it be to write something that did this?

If you point me in the right direction, I'll see what I can come up with.

Thanks!

N

[-- Attachment #2: Type: text/html, Size: 696 bytes --]

Re: How can you sort an Org clock table?

[Nick Dokos]

Noah Slater <nslater@tumbolia.org> writes:

> I posted a question on StackOverflow:
>
> http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
>
> Summary is: how do I sort an clock table by the % column?
>
> Is there anything "out there" I can use to get this working? If not,
> how complex a job would it be to write something that did this?
>
> If you point me in the right direction, I'll see what I can come up with.
>

Never tried on a clock table, but the following works on a generic
table, so I assume that it will work on a clock table too: put point
in the column by which you want to sort the table (in the body of the
table, not in the header) and say M-x org-sort RET n (I assume you
want numeric sorting, but org-sort provides several kinds). org-sort
is normally bound to C-c ^ too, so 

    C-c ^ n

should be all that's needed.
-- 
Nick

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 1033 bytes --]

Yeah, tried that. Doesn't work! :(


On 30 March 2014 23:24, Nick Dokos <ndokos@gmail.com> wrote:

> Noah Slater <nslater@tumbolia.org> writes:
>
> > I posted a question on StackOverflow:
> >
> >
> http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
> >
> > Summary is: how do I sort an clock table by the % column?
> >
> > Is there anything "out there" I can use to get this working? If not,
> > how complex a job would it be to write something that did this?
> >
> > If you point me in the right direction, I'll see what I can come up with.
> >
>
> Never tried on a clock table, but the following works on a generic
> table, so I assume that it will work on a clock table too: put point
> in the column by which you want to sort the table (in the body of the
> table, not in the header) and say M-x org-sort RET n (I assume you
> want numeric sorting, but org-sort provides several kinds). org-sort
> is normally bound to C-c ^ too, so
>
>     C-c ^ n
>
> should be all that's needed.
> --
> Nick
>
>
>

[-- Attachment #2: Type: text/html, Size: 1735 bytes --]

Re: How can you sort an Org clock table?

[Nick Dokos]

Noah Slater <nslater@tumbolia.org> writes:

> Yeah, tried that. Doesn't work! :(
>

AFAICT, it works fine on your first stackoverflow example.

There is probably no hope of getting this method to work the way you
want on your second example though: org-sort does not know anything
about the substructure of the table.  The only way I can think of is to
make the dynblock function that produces the table
(org-dblock-write:clocktable) do the sorting.


> On 30 March 2014 23:24, Nick Dokos <ndokos@gmail.com> wrote:
>
>     Noah Slater <nslater@tumbolia.org> writes:
>    
>     > I posted a question on StackOverflow:
>     >
>     > http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
>     >
>     > Summary is: how do I sort an clock table by the % column?
>     >
>     > Is there anything "out there" I can use to get this working? If not,
>     > how complex a job would it be to write something that did this?
>     >
>     > If you point me in the right direction, I'll see what I can come up with.
>     >
>    
>     Never tried on a clock table, but the following works on a generic
>     table, so I assume that it will work on a clock table too: put point
>     in the column by which you want to sort the table (in the body of the
>     table, not in the header) and say M-x org-sort RET n (I assume you
>     want numeric sorting, but org-sort provides several kinds). org-sort
>     is normally bound to C-c ^ too, so
>    
>         C-c ^ n
>    
>     should be all that's needed.
>     --
>     Nick
>

-- 
Nick

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 2202 bytes --]

Ah yes, I see that I have to move the point into the table cell. I was
trying with the table header. Slightly odd that. Means that it only works
on tables that aggregate clock times across multiple files, where the times
are put in the same cell. Can you replicate? If you do a clocktable with
the scope set to that file, then there's no way to order the cells.

How hard would it be to modify org-dblock-write do you think? In hours work
for someone familiar with elisp, but not the org codebase.


On 31 March 2014 03:06, Nick Dokos <ndokos@gmail.com> wrote:

> Noah Slater <nslater@tumbolia.org> writes:
>
> > Yeah, tried that. Doesn't work! :(
> >
>
> AFAICT, it works fine on your first stackoverflow example.
>
> There is probably no hope of getting this method to work the way you
> want on your second example though: org-sort does not know anything
> about the substructure of the table.  The only way I can think of is to
> make the dynblock function that produces the table
> (org-dblock-write:clocktable) do the sorting.
>
>
> > On 30 March 2014 23:24, Nick Dokos <ndokos@gmail.com> wrote:
> >
> >     Noah Slater <nslater@tumbolia.org> writes:
> >
> >     > I posted a question on StackOverflow:
> >     >
> >     >
> http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
> >     >
> >     > Summary is: how do I sort an clock table by the % column?
> >     >
> >     > Is there anything "out there" I can use to get this working? If
> not,
> >     > how complex a job would it be to write something that did this?
> >     >
> >     > If you point me in the right direction, I'll see what I can come
> up with.
> >     >
> >
> >     Never tried on a clock table, but the following works on a generic
> >     table, so I assume that it will work on a clock table too: put point
> >     in the column by which you want to sort the table (in the body of the
> >     table, not in the header) and say M-x org-sort RET n (I assume you
> >     want numeric sorting, but org-sort provides several kinds). org-sort
> >     is normally bound to C-c ^ too, so
> >
> >         C-c ^ n
> >
> >     should be all that's needed.
> >     --
> >     Nick
> >
>
> --
> Nick
>
>
>

[-- Attachment #2: Type: text/html, Size: 3195 bytes --]

Re: How can you sort an Org clock table?

[Nick Dokos]

Noah Slater <nslater@tumbolia.org> writes:

> Ah yes, I see that I have to move the point into the table cell. I was
> trying with the table header. Slightly odd that. Means that it only
> works on tables that aggregate clock times across multiple files,
> where the times are put in the same cell. Can you replicate? If you do
> a clocktable with the scope set to that file, then there's no way to
> order the cells.
>
> How hard would it be to modify org-dblock-write do you think? In hours
> work for someone familiar with elisp, but not the org codebase.
>

No idea - I have never used clocktables.

> On 31 March 2014 03:06, Nick Dokos <ndokos@gmail.com> wrote:
>
>     Noah Slater <nslater@tumbolia.org> writes:
>    
>     > Yeah, tried that. Doesn't work! :(
>     >
>    
>     AFAICT, it works fine on your first stackoverflow example.
>    
>     There is probably no hope of getting this method to work the way you
>     want on your second example though: org-sort does not know anything
>     about the substructure of the table.  The only way I can think of is to
>     make the dynblock function that produces the table
>     (org-dblock-write:clocktable) do the sorting.
>
>     > On 30 March 2014 23:24, Nick Dokos <ndokos@gmail.com> wrote:
>     >
>     >     Noah Slater <nslater@tumbolia.org> writes:
>     >
>     >     > I posted a question on StackOverflow:
>     >     >
>     >     > http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
>     >     >
>     >     > Summary is: how do I sort an clock table by the % column?
>     >     >
>     >     > Is there anything "out there" I can use to get this working? If not,
>     >     > how complex a job would it be to write something that did this?
>     >     >
>     >     > If you point me in the right direction, I'll see what I can come up with.
>     >     >
>     >
>     >     Never tried on a clock table, but the following works on a generic
>     >     table, so I assume that it will work on a clock table too: put point
>     >     in the column by which you want to sort the table (in the body of the
>     >     table, not in the header) and say M-x org-sort RET n (I assume you
>     >     want numeric sorting, but org-sort provides several kinds). org-sort
>     >     is normally bound to C-c ^ too, so
>     >
>     >         C-c ^ n
>     >
>     >     should be all that's needed.
>     >     --
>     >     Nick
>     >
>    
>     --
>     Nick
>

-- 
Nick

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 2760 bytes --]

Okay thanks. If anyone else does know, I'd really appreciate it. Thanks! :)


On 31 March 2014 14:45, Nick Dokos <ndokos@gmail.com> wrote:

> Noah Slater <nslater@tumbolia.org> writes:
>
> > Ah yes, I see that I have to move the point into the table cell. I was
> > trying with the table header. Slightly odd that. Means that it only
> > works on tables that aggregate clock times across multiple files,
> > where the times are put in the same cell. Can you replicate? If you do
> > a clocktable with the scope set to that file, then there's no way to
> > order the cells.
> >
> > How hard would it be to modify org-dblock-write do you think? In hours
> > work for someone familiar with elisp, but not the org codebase.
> >
>
> No idea - I have never used clocktables.
>
> > On 31 March 2014 03:06, Nick Dokos <ndokos@gmail.com> wrote:
> >
> >     Noah Slater <nslater@tumbolia.org> writes:
> >
> >     > Yeah, tried that. Doesn't work! :(
> >     >
> >
> >     AFAICT, it works fine on your first stackoverflow example.
> >
> >     There is probably no hope of getting this method to work the way you
> >     want on your second example though: org-sort does not know anything
> >     about the substructure of the table.  The only way I can think of is
> to
> >     make the dynblock function that produces the table
> >     (org-dblock-write:clocktable) do the sorting.
> >
> >     > On 30 March 2014 23:24, Nick Dokos <ndokos@gmail.com> wrote:
> >     >
> >     >     Noah Slater <nslater@tumbolia.org> writes:
> >     >
> >     >     > I posted a question on StackOverflow:
> >     >     >
> >     >     >
> http://stackoverflow.com/questions/22749704/how-can-you-sort-an-org-clock-table
> >     >     >
> >     >     > Summary is: how do I sort an clock table by the % column?
> >     >     >
> >     >     > Is there anything "out there" I can use to get this working?
> If not,
> >     >     > how complex a job would it be to write something that did
> this?
> >     >     >
> >     >     > If you point me in the right direction, I'll see what I can
> come up with.
> >     >     >
> >     >
> >     >     Never tried on a clock table, but the following works on a
> generic
> >     >     table, so I assume that it will work on a clock table too: put
> point
> >     >     in the column by which you want to sort the table (in the body
> of the
> >     >     table, not in the header) and say M-x org-sort RET n (I assume
> you
> >     >     want numeric sorting, but org-sort provides several kinds).
> org-sort
> >     >     is normally bound to C-c ^ too, so
> >     >
> >     >         C-c ^ n
> >     >
> >     >     should be all that's needed.
> >     >     --
> >     >     Nick
> >     >
> >
> >     --
> >     Nick
> >
>
> --
> Nick
>
>
>

[-- Attachment #2: Type: text/html, Size: 4041 bytes --]

Re: How can you sort an Org clock table?

[Bastien]

Hi Noah,

from master, you can now use a :sort parameter in clocktable
to sort a column.  For example:

#+BEGIN: clocktable :maxlevel 2 :scope file :sort (2 . ?t)
#+CAPTION: Clock summary at [2014-04-16 mer. 18:12]
| Headline     |   Time |
|--------------+--------|
| *Total time* | *0:34* |
|--------------+--------|
| STRT abc     |   0:15 |
| STRT def     |   0:19 |
#+END:

The (2 . ?t) means: "sort the second column by time."

Let me know if it works for you,

-- 
 Bastien

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 628 bytes --]

Thanks Bastien! I'll look into this and report back.


On 16 April 2014 18:26, Bastien <bzg@gnu.org> wrote:

> Hi Noah,
>
> from master, you can now use a :sort parameter in clocktable
> to sort a column.  For example:
>
> #+BEGIN: clocktable :maxlevel 2 :scope file :sort (2 . ?t)
> #+CAPTION: Clock summary at [2014-04-16 mer. 18:12]
> | Headline     |   Time |
> |--------------+--------|
> | *Total time* | *0:34* |
> |--------------+--------|
> | STRT abc     |   0:15 |
> | STRT def     |   0:19 |
> #+END:
>
> The (2 . ?t) means: "sort the second column by time."
>
> Let me know if it works for you,
>
> --
>  Bastien
>

[-- Attachment #2: Type: text/html, Size: 1056 bytes --]

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 1030 bytes --]

Hmm. I'm not sure this is working.

If you add ":link" to the BEGIN blog, the sorting doesn't appear to kick
in. Bug, I expect.

If I remove ":link" I can see that some sorting is taking place. But it's
not what I expect.

With "?t" I am getting this sort order:

- (empty cell)
- "4:02"
- "1d 5:15"
- "1d 9:08"
- "14:19"

With "?T" I am getting this sort order:

- "14:19"
- "1d 9:08"
- "1d 5:15"
- (empty cell)

Note that this isn't the reverse order.



On 16 April 2014 18:26, Bastien <bzg@gnu.org> wrote:

> Hi Noah,
>
> from master, you can now use a :sort parameter in clocktable
> to sort a column.  For example:
>
> #+BEGIN: clocktable :maxlevel 2 :scope file :sort (2 . ?t)
> #+CAPTION: Clock summary at [2014-04-16 mer. 18:12]
> | Headline     |   Time |
> |--------------+--------|
> | *Total time* | *0:34* |
> |--------------+--------|
> | STRT abc     |   0:15 |
> | STRT def     |   0:19 |
> #+END:
>
> The (2 . ?t) means: "sort the second column by time."
>
> Let me know if it works for you,
>
> --
>  Bastien
>

[-- Attachment #2: Type: text/html, Size: 1838 bytes --]

Re: How can you sort an Org clock table?

[Bastien]

Noah Slater <nslater@tumbolia.org> writes:

> If you add ":link" to the BEGIN blog, the sorting doesn't appear to
> kick in. Bug, I expect.

Please provide a reproducible example.

-- 
 Bastien

Re: How can you sort an Org clock table?

[Noah Slater]

[-- Attachment #1: Type: text/plain, Size: 762 bytes --]

Here's a broken example:

#+BEGIN: clocktable :maxlevel 2 :link :scope file :sort (2 . ?T)
#+END:

* A
CLOCK: [2014-05-24 Sat 10:00]--[2014-05-24 Sat 11:00] =>  1:00
* B
CLOCK: [2014-05-24 Sat 11:00]--[2014-05-24 Sat 12:30] =>  1:30
* C
CLOCK: [2014-05-24 Sat 12:30]--[2014-05-24 Sat 15:00] =>  2:30

If you run C-c C-c on the clocktable, it will update, but the sorting is
wrong. It should be in reverse order because it's "T" and not "t".

Now: remove ":link" and try again. The sorting works!


On 20 April 2014 12:22, Bastien <bzg@gnu.org> wrote:

> Noah Slater <nslater@tumbolia.org> writes:
>
> > If you add ":link" to the BEGIN blog, the sorting doesn't appear to
> > kick in. Bug, I expect.
>
> Please provide a reproducible example.
>
> --
>  Bastien
>

[-- Attachment #2: Type: text/html, Size: 1459 bytes --]

Re: How can you sort an Org clock table?

[Bastien]

Hi Noah,

Noah Slater <nslater@tumbolia.org> writes:

> Here's a broken example:
>
> #+BEGIN: clocktable :maxlevel 2 :link :scope file :sort (2 . ?T)
> #+END:

You need :link t or :link nil for this block to be correctly formatted.

HTH,

-- 
 Bastien