Allocation Compliance Pie Chart – SQL

The Allocation Compliance Pie Chart portlet gives a view of active resources’ allocation compliance within a date range and OBS displayed in a pie chart.  It allows the user to the percentage of resources over, under, and adequately staffed on projects over a selected time period.   This portlet leverages the daily allocation and daily availability slices as well as only active investments.  The portlet provides filters for specific dates (required) and OBS.