'm trying to setup a RAG (Red, Amber and Green) status for all my projects based on the following co

[suvarna dixit]

I'm trying to setup a RAG (Red, Amber and Green) status for all my projects based on the following conditions

Red: Time Spent is 20% over Original estimate Amber : Time spent is 5% over Original Estimate Green : Time spent is < = Original Estimate

[Katerina Kovriga {Stiltsoft}]

Hi @suvarna dixit ,

We can suggest trying our app - Table Filter and Charts for Confluence.

It's Table Transformer macro allows you to set statuses based on different conditions (the macro works with manually created and Jira generated tables).

Here is an example regarding your case:

SELECT *,
CASE
WHEN (T1.'Time Spent, h'*100/T1.'Original Estimate, h' - 100) >= 20
THEN FORMATWIKI("{status:colour=Red|title=Red}")
WHEN (T1.'Time Spent, h'*100/T1.'Original Estimate, h' - 100) >= 5 AND (T1.'Time Spent, h'*100/T1.'Original Estimate, h' - 100) < 20
THEN FORMATWIKI("{status:colour=Yellow|title=Amber}")
ELSE FORMATWIKI("{status:colour=Green|title=Green}")
END AS 'RAG Status'
FROM T*

Maybe this may help your case.

[suvarna dixit]

to use this what s the price

[suvarna dixit]

If just want to showcase if due date is > 31 dec then AMBER

Due date = <today> then red

any suggestion in Jira or confluence

[Katerina Kovriga {Stiltsoft}]

You'll be able to compare dates via the Table Transformer macro as well, here is a somewhat similar example from the Community (the last comment).

The cost of the app for different tiers is shown on the Marketplace.

[Katerina Kovriga {Stiltsoft}]

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.