2 Replies Latest reply: Sep 30, 2015 3:42 PM by Liron Baram RSS

    Colour Dimensions in Script or in application Sense

    Sarb Nyota

      Hi,

       

      I have DocumentType Dimension- which has 3 types {Invoice, Credit Note, Cancelled}

       

      I want these to be Invoice = lightGreen, Credit Note = lightRed , Cancelled = lightmagenta in pie chart and other graphs where this dimension has been used.

       

      How can i do that?

       

      I have tried this in the colour expression.

      If(DocumentType = 'Invoice',Lightgreen(),

      If(DocumentType = 'Credit Note',LightRed(),

      If(DocumentType = 'Cancelled ',Lightmagenta(),)))


      This is not working.


      Can someone please suggest the right expression or if there is a way i can add this in the script and use that in the calculation.


      Thanks