Forum Discussion
Historic RAG
Hi
Does anyone know a simple way to collect historic RAG statuses etc. from Project Online? We want to show month on month changes to statuses however all reporting is 'live' - help!:)
Thanks
Paul
Hi,
This might not be a solution for you but as we had the same use case I made following process as a workaround and thought to share it with you in case it helps:
1. A custom list in Project Site (SharePoint) created.
2. on each reporting round (weekly or monthly, etc) a new item created. We have status commentary beside the RAG status for each project.
3. in reporting solution (in our case: Power BI) we pull all the items from that custom list and then we can review history of RAG changes.
PS: as you rightfully mentioned currently the RAG field in Project Online doesn't keep the history.
Regards,
Naser
Hi Paul,
The status of each project is independent, therefore we have each project has its own list of status and RAG list which get updated with the its project manager on weekly basis.
Also remember that project site (SharePoint site) is dedicated to each project in Project Online environment.
I am not sure what do you mean with automation; the updates are done by project managers manually and the report is automatically populated in Power BI. This is overall project health which is based on all aspects of the projects. we have other RAGs like cost or schedule and etc. which is rule based.
Regards,
Naser
Thanks Paul_Mather this does get close, but the information we want to collate is from the lists (same format) on the various project sites that sit are basically subsites to the PWA.
Is there a flow that will extract the same fields from these lists and copy them to another list?
Thanks!
Hi pauleast ,
You will find Flow samples either in blogs posts or as templates that will get you so far but you will need to build this flow - for example some of this Flow would be applicable: https://pwmather.wordpress.com/2019/07/11/projectonline-risk-to-issue-escalator-built-using-microsoftflow-office365-sharepoint-javascript-ppm-projectmanagement-msproject-pmot-pmo/
as this reads a list item and creates a new list item using some of the data from the original list item. This article also includes something similar: https://support.microsoft.com/en-gb/help/4467880/how-to-copy-items-between-two-sharepoint-lists-by-using-flow
Hope that helps
Paul
Here is a very simple field
formula (for a custom task duration field) which gets close to what I think
you want: IIf(ProjDateValue("NA")<>[Actual
Finish],-99999,ProjDateDiff(now(),[Finish]))
As you can see this calculates a variance between Now() and the scheduled
finish date. If the task has an actual finish date, we set this value to a
large negative number.
For the indicators, compare to the value: for example:
- Less than -200 d: Blue circle
- Equal or less than 0: Red circle
- Equal or less than 7d: Yellow circle
- Greater than 7d: Green circle
