We have a project that uses a RAG (Red, Amber, Green) custom field for project status and the team would like to see the date that an issue entered a specific RAG, so we can provide a visual showing how many days an issue has been Red, Amber, Green etc.
Can this be achieved by pulling data from the history tab somehow to populate another custom field for reporting?