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.