Conditional Cell Formatting with Jira status

Questions & Answers
1

Hi, I want to highlight issue created = 1 in On Track status, how to make this possible?
I tried conditional cell formatting, however it wont be highlighted

Status | Issue Created
On Track | 1

image
image1446×745 59.1 KB

Thanks

2

Hi @rikamandasari

Welcome to the eazyBI community!

You may change the condition: add one by the status name and another by the count of created issues in this status. Use [Measures].[Issues created]>0 if to set formating for 1 or more issues in this status or [Measures].[Issues created]=1 of to color the row with exactly 1 issue in this status.

CASE WHEN
[Status].CurrentMember.Name = "On Track"
AND
[Measures].[Issues created]>0
THEN
"On Track"
END

See the cell formatting screen (I used status “Open” instead of On Track):

image
image1594×980 90.5 KB

How it looks in the report with cell formatting applied:

image
image1634×766 54.3 KB

Best,
ilze / support@eazybi.com