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

    Color using GetCurrentField()

    Juan Escobar



      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.