Expand my Community achievements bar.

Reporting on Project Duration

Avatar

Level 3

Hello,

 

I would like to see the average durations of projects relating to a specific programme - and for ease show in a chart (bar/line).

I am in Project Report and have pulled in the DURATION column - however when I go to the chart I cannot choose it as a data point - why is that ? I can choose not have a chart and the duration for each project shows. 

 

Thank You

 

Emma

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

According to the API the actual duration isn't groupable so you wouldn't be able to use it in a chart.

KellieGardner_0-1704381610899.png

 

 

One suggestion would be to create a calculated custom field on your project custom form to capture the actual duration and then use that column to pull into your report and then group by it for your chart. 




Avatar

Level 3

Thank You - am going to try now. 

 

Thank you for your help

 

Emma