Help

                h2. Project Metrics
                
                {% two-columns %}
                {% left-column %}
                
                {% dashboard-half-panel %}
                {% panel-heading %}Story Progress per Iteration {% panel-heading %}
                {% panel-content %}
                
                {{ 
                stack-bar-chart 
                conditions: 'Type' = 'Story' AND NOT 'Iteration' = NULL
                labels: SELECT DISTINCT 'Iteration'
                cumulative: true
                series: 
                - label: Scope
                color: red
                type: line
                data: SELECT 'Iteration', SUM('Story Estimate - Original')
                - label: Analysis Complete
                color: green
                type: line
                data: SELECT 'Iteration', SUM('Story Estimate - Original') WHERE 'Story Status' = 'Ready for Development' and 'Iteration' IS NOT NULL
                - label: Development Complete
                color: orange
                type: line
                data: SELECT 'Iteration', SUM('Story Estimate - Original') WHERE 'Story Status' = 'Ready for Testing' and 'Iteration' IS NOT NULL
                - label: Signed Off
                color: blue
                type: line 
                data: SELECT 'Iteration', SUM('Story Estimate - Original') WHERE 'Story Status' = 'Development Complete' and 'Iteration' IS NOT NULL
                }}
                
                
                {% panel-content %}
                {% dashboard-half-panel %}
                
                {% dashboard-half-panel %}
                {% panel-heading %}Feature Completeness {% panel-heading %}
                {% panel-content %}
                
                {{
                ratio-bar-chart
                totals: SELECT 'Feature', COUNT(*) WHERE Type = Story
                restrict-ratio-with: 'Story Status' = 'Accepted'
                color: purple
                }}
                
                {% panel-content %}
                {% dashboard-half-panel %}
                
                {% left-column %}
                {% right-column %}
                
                {% dashboard-half-panel %}
                {% panel-heading %}Task Progress - Current Iteration {% panel-heading %}
                {% panel-content %}
                
                {{
                stack-bar-chart
                conditions: 'Type' = 'Task' and 'Iteration' = 5
                labels: SELECT DISTINCT 'Parent Story' ORDER BY 'Parent Story'
                cumulative: false
                series:
                - label: Tasks Not Started
                color: red
                data: SELECT 'Parent Story', SUM('Task Estimate') WHERE 'Task Status' = 'Not Started'
                empty-columns: true
                - label: Tasks In Progress
                color: yellow
                data: SELECT 'Parent Story', SUM('Task Estimate') WHERE 'Task Status' = 'In Progress'
                empty-columns: true
                - label: Tasks Completed
                color: green
                data: SELECT 'Parent Story', SUM('Task Estimate') WHERE 'Task Status' = 'Complete'
                empty-columns: true
                }}
                
                {% panel-content %}
                {% dashboard-half-panel %}
                
                {% dashboard-half-panel %}
                {% panel-heading %} Priority split of all stories {% panel-heading %}
                {% panel-content %}
                
                {{
                pie-chart
                data: SELECT 'Priority', count(*) WHERE 'Type' = 'Story'
                }}
                
                {% panel-content %}
                {% dashboard-half-panel %}
                
                {% dashboard-half-panel %}
                {% panel-heading %}Velocity per iteration{% panel-heading %}
                {% panel-content %}
                
                |*Sprint*|*Velocity*|
                | 1 | {{ value query: SELECT SUM('Story Estimate - Original') WHERE 'Iteration' = 1 AND 'Type' = 'Story'}} |
                | 2 | {{ value query: SELECT SUM('Story Estimate - Original') WHERE 'Iteration' = 2 AND 'Type' = 'Story'}} |
                | 3 |{{ value query: SELECT SUM('Story Estimate - Original') WHERE 'Iteration' = 3 AND 'Type' = 'Story'}}  |
                
                {% panel-content %}
                {% dashboard-half-panel %}
                
                {% right-column %}
                
                {% two-columns %}
                
                {% dashboard-panel %}
                {% panel-heading %}Story Points in each status by Priority{% panel-heading %}
                {% panel-content %}
                
                {{
                pivot-table
                conditions: not 'Story Status'= 'Out of Scope' and 'Type' = 'Story' 
                columns: 'Story Status'
                rows: Priority 
                aggregation: SUM('Story Estimate - Original')
                totals: true
                empty-columns: true
                empty-rows: false
                
                }}
                
                {% panel-content %}
                {% dashboard-panel %}
                
                {% dashboard-panel %}
                {% panel-heading %}Wiki Pages{% panel-heading %}
                {% panel-content %}
                
                [[Demo wiki page]]
                
                {% panel-content %}
                {% dashboard-panel %}