8 Replies Latest reply: Apr 26, 2018 11:23 AM by Robbert Sam-Sin RSS

    Pick(Match()) using a variable

    Robbert Sam-Sin

      Hey Guys,

       

      I would like to show several different values in my line graph. Therefor I want to assign different colors to different lines.

       

      In my coloring expression I would like to change the colors to company colors. However this isn't working.

      When coloring is on auto all 3 lines will get different colors, so it should be possible to solve with a formula.

       

      The formula is based upon one dimension with several values.

       

      Variable contains: =getfieldselections(Item) =vRelativeSelections

       

      pick(match(Item, '=$(vRelativeSelections)',red(),Yellow(),black()))

       

       

      Thanks is advance.