11 Replies Latest reply: Jan 30, 2014 6:10 AM by Mir Mir RSS

    Pie chart - calculated color only for one value

      Hi community! :-)

      Please help me with expression for pie chart color. I have questionare with few questions and one pie chart to show them one by one using this expression to choose dimension (question):

      =$(=subfield(GetFieldSelections([Question_number]),',',))

       

      Each question has different number and type of possible answers, but all has one common - 'Others'.

      For example I'm using this for pie popout: =$(=subfield(GetFieldSelections([Question_number]),',',))='Others'

       

      And now I want to use something similar for set color of that 'Others', but not of the rest.

      Somthing like this? if($(=subfield(GetFieldSelections([Question_number]),',',))='Others', RGB(255,0,0),Rand)