[O] Interaction of Agenda with DEADLINE & SCHEDULED

[Stephan Fabel]

When creating a custom agenda view, it is often desirable to express a
relationship between a given task and meaningful dates, such as DEADLINE
and SCHEDULED. It seems that with org-mode, and especially in the agenda
view, it is not (yet?) possible to express that.

For example, how would one create a custom agenda view that

- shows all accomplished tasks within the DEADLINE last week
- shows all accomplished tasks that missed the DEADLINE last week

Then does the same for the coming week, i.e.

- show all tasks which are due in the next week, i.e., within the
  DEADLINE
- show all tasks which are overdue

Ideally, the interaction could even be more informational, so for
example, analysis of the available work time next week (assuming 40
hours for example) vs. the total estimated effort of all of the above
tasks, helping to answer the question of whether all tasks are even
achievable given the amount of available work time.

Another potential -and very valuable- analysis could be a recommendation
of order given DEADLINE, priority and effort over a period of time, for
example the next week. What should one do first, then second, etc. to
maximize output over a given period of time?

I have been looking for a discussion of these type of questions in the
documentation, worg and other places like EmacsWiki and haven't really
found anything.

Thanks for any pointers,

Stephan