2 Replies Latest reply: Dec 26, 2013 11:27 AM by Juan Escobar RSS

    Color using GetCurrentField()

    Juan Escobar

      Hi,

       

      I have a RGB set for one dimension, but I'm working on a Pie Chart with two dimensions. Now, If I set the expression color based on the RGB(R, G, B) when I drill-down in the group all the colors are gone (it looks black). How can I have the RGB for the first dimension and like random colors for the second one (can be the original ones).

       

      I tried this expression:

       

      If(GetCurrentField([Actividad-Oportunidad]) = 'Oportunidad', RGB(R, G, B), RGB(R * rand(), G * rand(), B * rand()))
      

       

      But I didn't like the result.

       

      Thanks in advance, kindest regards.