We currently have a confluence page for reporting project status - which is essentially a table which lists the project name/ manager and then a RAG status (using the status gadget) for project health/schedule/budget. It is manually updated by the PM (we are working towards full jira integration but not ready to do that yet).
1. Can you do an automated pie chart that looks at the status gadget in one of the table columns (i.e. project health) and summarises how many are in each RAG status category.
2. Is there a better way of doing this - bearing in mind we are not yet ready to fully integrate with Jira.