...

The sprint to show is selected in a drop-down. Here we can see, for instance, that Dave is able to work 10 hours this sprint, is assigned one issue (SKP-14), which is estimated to take 30h, so Dave would be at 300% capacity unless we change things. There are 49 hours' worth of unassigned issues.

Implementation

The report is implemented as a giant parametrized SQL query running within a Confluence page, with the SQL running against the JIRA database.

...