Reflecting the child panels RAG status on to parent dashboard

Question : In Grafana, we have requirement to capture RAG (Red, Amber, Green) status of components in child dashboard and use it in parent Grafana dashboard to update the status of parent dashboard based on linked child dashboard components RAG status. Is there a way by which this can be achieved.

Current approach : We are using queries in both parent and child dashboard to get the RAG status of status panels in both child and parent dashboards. Parent dashboard includes cumulative of all queries used in child dashboard panels. We need to repeat the same queries used in child dashboard in the parent dashboard to get the RAG status

Is there a way to capture RAG status of panels in child dashboard and use it to update the status of parent dashboard instead of repeating all the queries in parent level dashboard.