5 Replies Latest reply: Jun 26, 2018 10:24 AM by Anand Kumar RSS

    Change color for stacked barchart, using Wildmatch

    Daniel Sørensen

      HI

       

      I have this stacked bar chart.

      Udklip.JPG

      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))