Conditional Formatting for Number of Jira Issues in Confluence Table

[Sophie Ng]

Hi, 

I would like to insert a conditional formatting for the status of each project. So in the status column, i would like to fill the cell with a red color if the overdue tickets/total open tickets > 75% and green otherwise. 

I have tried using table transformer with the following code: 

SELECT *, FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Overdue Tickets'/T1.'Total Open Tickets' >= "0.75" THEN "hex for red" ELSE "hex for green" END + "}") AS 'Status', FROM T1

However, I keep getting a parsing error as shown. This is my first time using confluence so any help would be greatly appreciated. thanks!

[Nikita Kamai]

Hello, @Sophie Ng 

This is Nikita from Stiltsoft.

Please, try the following query:

SELECT *,
FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Overdue Tickets'/T1.'Total Open Tickets' >= "0.75"
THEN "red" ELSE
"green" END + "}{cell}") AS 'Status'
FROM T1

[Benjamin]

Hi @Sophie Ng ,

You may want to refer to this post to get some additional thoughts on handling your case.

https://community.atlassian.com/t5/Confluence-questions/Conditional-Formatting-for-Confluence-tables/qaq-p/1568284

Hope it helps.

-Ben

[Katerina Kovriga {Stiltsoft}]

Hi @Sophie Ng ,

I see that you have an extra comma between AS 'Status', FROM T1 (and your mistake points at this abstract as well).

Unfortunately, I'm out of the office for the next 10 days - please go to our support team.