Projects by Schedule Currency – Pie w/ Drilldown – SQL

Pie Chart Portlet displays counts of active projects with various Stale ratings. Calculation is Percent Stale Tasks = number of open (not completed) tasks with a finish date over 15 days old, divided by total open tasks.  Filterable by OBS structure and project manager.  Data label = project count.  Mouse-over and Legend labels = stale rating.  More than 90% Stale means 90 to 100% of open tasks on a project have finish dates older than 15 days.  More than 80% Stale means 80 to 89% of open tasks on a project have finish dates older than 15 days.  Less than 70% Stale means fewer than 70% of open tasks on a project have finish dates older than 15 days.

By clicking on pie slice, a drilldown grid portlet appears with listing of projects and their Stale Ratings.