Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Project completion bar chart

Highlighted
patrick-sa
Regular Collector

Project completion bar chart

Hi,
I'm looking for a barchart that lists a project and its completion percentage(this is based on the workplan percentage completion).The standard project list portlet displays the required info only that the requirement is that it should be a barchart.

just trying my luck.

thankss.
2 REPLIES
patrick-sa
Regular Collector

Re: Project completion bar chart

SELECT pm.project_name PROJECT_NAME, round(wta.perc_complete,0) PERCENT_COMPLETE, 'Red' COLOUR, pm.project_id PROJECT_ID
From
pm_projects pm ,pm_work_plans pwp ,wp_tasks wt ,wp_task_actuals wta
where pm.project_id = pwp.project_id
and pwp.entity_type = 'WORK_PLAN'
and pwp.work_plan_id = wt.work_plan_id
and wt.sequence_number = 0
and wt.task_actuals_id = wta.actuals_id
patrick-sa
Regular Collector

Re: Project completion bar chart

solution as above
//Add this to "OnDomLoad" event