2 Replies Latest reply: Sep 27, 2016 9:37 AM by ioannis giakoumakis RSS

    How to shade my Top 5 Customers in my Bar Chat with this Rank expression?

    John Blomqvist

      Hi all,

       

      I have the following bar chart:

      Capture.PNG

       

       

      My background colour expression is:

      If(Rank(Sum(LineSalesAmount), CompanyName)<=5, LightBlue(), LightGray())

       

      How can I get different shades of blues for my top 5 customers please? E.g. Darkest blue colour for customer ranked 1 and lighter shading up to 5