3 Replies Latest reply on Sep 13, 2018 1:59 PM by swaroop.gantela

    Colouring a variable width bar chart based on a different dimension

    Kathryn Berry

      I have created the following variable width bar chart to show the cumulative spend in 2016 by project name with IRR on the y axis.

       

      I want to colour the individual bars based on a different dimension - the channel of trade group.

       

      I have tried to create a combination dimension to use as the label on this

      [Channel Of Trade (group)] + [Project Title]

       

      And then create a calculation of this to do the colours along these lines

      if contains([combination for piano chart],'Lubricants') then 1

      elseif contains ([combination for piano chart],"Retail") then 2

      else 0

      END

       

      However if I then move this into the colour it just filters out those fields rather than putting in different colours.

       

      Any suggestions as to what I am doing wrong here?

       

      Many thanks

       

       

      bar chart.png