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

    Colour Dimensions in Script or in application Sense

    Sarb Nyota



      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.