I've found the "Average Time in Status" report, but first off it doesn't seem to ever return anything useful, and secondly, it seems to have an axis that isn't very useful. What I want to know is, for a set of issues determined by a filter, for each status or step in a workflow, how much time was spent in that status?
The Y axis would be amount of time spent. The X axis would be each status or step in a workflow. This allows me to understand where my team is spending the majority of their time.