5 Replies Latest reply: Feb 2, 2017 8:33 AM by Aehman K RSS

    Can you colour different segments of a line graph differently?

    Paul Kumeta

      I have built a line graph of Month Complaint Raised (X axis) against Number of Complaints (Y axis). The dimension for the graph is MonthStart([Date_Comp_Raised]) and the expression is count(Complaint_Number).

       

      Would it be possible to use an expression to colour certain date periods different colours?

       

      I have used the following expression: if([Date_Comp_Raised] >= date(42234) and [Date_Comp_Raised] <= date(42447), rgb(96,162,80),black()). This works if the dates aren't grouped by 'MonthStart' but when they are the whole graph turns black.