Re-arrange columns in agenda clockreport?

Question

My Agenda clock-report is kinda wide and columns are all over the place.

My agenda clock report plist is as following:

 '(org-agenda-clockreport-parameter-plist
   (quote
    (:tcolumns 2 :level\  t :link t :maxlevel 5 :narrow 60 :formatter my-org-clocktable-notodo :properties
           ("Effort" "CLOCKSUM" "CLOCKSUM_T"))))

The Effort/clock columns are placed before headings:

| File      | Effort | CLOCKSUM | CLOCKSUM_T | ITEM | Headline  ..| Time |

Is it possible to put the effort/clock columns at the end, after the heading instead like so:

| File      | ITEM | Headline  ..| Time | Effort | CLOCKSUM | CLOCKSUM_T |

Answer 1

A roundabout way of doing this is to simulate a clock report with column view:

#+BEGIN: columnview :id local :format "%70ITEM(Task) %Effort{:} %CLOCKSUM{:} %CLOCKSUM_T{:}"

#+END:

It avoids problems that clock reports have such as indentation and TODO keywords in headlines, but you don't get the fancy time break out or headline linking, if you are using those features.

Column view and clock reports seem to be equally lacking when it comes to sorting.

You might be able to use something like org-collector to build something custom. The code is quite short.