Change color for stacked barchart, using Wildmatch

[varmekontrol]

HI

I have this stacked bar chart.

Measure 1:

count(distinct if(WildMatch(sgw_operation_state_art, '*Exchange*') and sgw_deactivation_date<=0, gateway_id))

Measure 2:

count(distinct if(WildMatch(sgw_operation_state_art, '*Check*') and sgw_deactivation_date<=0, gateway_id))

I would like to color these two bars.

Attempt 1: (Does not work)

if(wildmatch(sgw_operation_state_art, '*Exchange*'), RGB(230,63,12),if(wildmatch(sgw_operation_state_art, '*Check*'), RGB(230,63,12)))

Attempt 2: (does not work)

pick(WildMatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12), RGB(230,63,12))

[YoussefBelloum]

Hi,

I don't see a problem with your coloring expressions, both should work fine.. did you try to check and uncheck the checkbox under the coloring expression box ?

[agigliotti]

what are the chart dimensions and measures ?

[varmekontrol]

Measure 1:

count(distinct if(WildMatch(sgw_operation_state_art, '*Exchange*') and sgw_deactivation_date<=0, gateway_id))  

count(distinct if(WildMatch(sgw_operation_state_art, '*Check*') and sgw_deactivation_date<=0, gateway_id))  

[varmekontrol]

The box has been checked and unchecked with no result.

[imhappiee]

Hi

try this two and see if these are working

pick(WildMatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12))

else

if(wildmatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12)) 

Anand