How to ADD Dynamic RAG status to confluence

Question

I want to add a RAG status for passed test cases in Confluence using Jira macro, and it should be dynamic. For example, if the percentage of passed test cases is 70, then it should display as Green. If it's between 60 and 70, it should show as Amber. If it's below 50, it should be displayed as Red

Anand_18b8kj · Answer

@Sayed Bares [ServiceRocket] Confluence Cloud and for test cases using Zephyr Squad

Anand_18b8kj · Answer

Hi @Sayed Bares  we are using Confluence Cloud

Stiltsoft support · Answer

Hi @Anand ,

Not sure if this is your case but maybe it will suit your needs: our company develops the Table Filter and Charts for Confluence app (available for Cloud and Data Center).

Our macros support not only manually created tables but dynamically changing tabular macros such as Jira Issues, Page properties Report, etc. as well.

So, if your Jira is connected to your Confluence, you may show your issues in Confluence using the Jira Issues macro (like you've mentioned in your original post).

Then you may wrap your Jira Issues macro in the Table Transformer macro, calculate the required data and set colored statuses (or paste some text and color cells' background) based on the calculated values using the CASE WHEN conditions.

If you have the app installed but you are stuck with the SQL query, you may refer to our support. Attach a screenshot of your Jira Issues macro (in a published state with visible headers) and we'll help you.

If you are not familiar with app, we can discuss your use case during a live demo session.