Microsoft SharePoint 2013 (Online)
Problem Statement; SharePoint Online has limited functions, including Admin console and no out of the box graph capabilities. (Excel Services are available for Cross Tab and Graphics, however this is not desirable)
Requirement 1
Develop a 3D Doughnut Chart for Risks based on a List View “Risk Ratings”
• Produce some form of Cross tab to calculate the total number of Open uncontrolled risk (Inherent Risk) based on the risk category.
Example:
Risk Register > Inherent Risk (View)
Columns > Risk Count Risk Rating
1 Critical
1 Critical
1 High
1 Moderate
1 Moderate
1 Medium
1 Low
1 Low
1 Low
1 Very Low
Cross Tab Results
Risk Rating Risk Count
Critical 2
High 1
Moderate 2
Medium 1
Low 3
Very Low 1
Doughnut Chart Colours
Risk Rating Color
Critical Dark Red
High Red
Moderate Orange
Medium Yellow
Low Green
Very Low Light Green
Requirement 2.
Doughnut Chart Risk Rating Legend to be displayed & Doughnut to have count of Risk Ratings within Doughnut Segments.
Requirement 3.
Graph size no larger than 4 cm x 4cm
Requirement 4.
Code to be supplied, google charts API preferable.
Requirement 5.
No special rights other than Site Admin to implement Solution
Requirement 6.
Graph is live, any new or change to Risks will be reflected in graphs
Assumptions
• Assume Risk Register filter View has removed all closed risks
• Code is reusable and modifiable by client enabling Inherent & Residual Risk Calculation by changing the List View Name
• Working Code required within 7 days