3 Replies Latest reply: Aug 28, 2017 8:12 AM by Anna Ebner RSS

    'value colors' from June 2017 release are grey on calculated dimension

    Neil FitzPatrick

      Hello,

       

      I am trying to use the new value colours function. as an example I'm using some dummy data and I'm trying to colour my top 3 sales guys individually.

      I have this calculated dimension:

      =if((aggr(rank(sum(Sales)),EmployeeName)<=3),EmployeeName)


      Which works as you can see by this simple bar chart:top 3 emp by sumsales.png


      Now I'm trying to use the new functionality:

      value colours.png


      But when I use the colour by dimension option, everything turns grey.


      value colours problem.png


      I did find a work around for my problem by using all employees as a dimension and colouring the employees in question in that dimension, but I feel like it should be possible in the way I was trying originally.


      Any thoughts?