Format table by Jira label

Questions & Answers
,
1

Hey dear community, I’m trying to get a table report with other formatting rules than the ones based on status. The idea is to format based on the labels an issue might or might not have and I’m struggling to get this done.
I’ve tried something like:

CASE WHEN
  [Measures].[Issue labels] = "LO_Q2"
THEN
  "Leftover" 
END

but as Labels are multiple values I believe this is trying to get the issues there have only “LO_Q2” and is not what I intend. Any help please?

PS, sorry if I’m getting over some basic stuff, I’ve started to work with EazyBI just now. Thanks in advance!

2

Hi @Gui,
Welcome to eazyBI Community :wave:

You can use this formula to filter issue labels; as it is a multi-value field, then better to use a regular expression to find the value you are interested in. Also, CoalesceEmpty() will return you an empty string in case “Issue labels” are empty:

CASE WHEN
  CoalesceEmpty([Measures].[Issue labels], '') MATCHES ".*app_2.*"
THEN
  "Leftover" 
END

In the report, you can test your custom formula and then use it in cell formatting as a custom formula:

eazyBI_test_custom_formula
eazyBI_test_custom_formula1220×1220 141 KB

See some more examples of cell formatting here in this video " Paint With Your Data in eazyBI"

Best,
Gerda // support@eazyBI.com