0 Replies Latest reply: Jan 31, 2017 7:23 AM by Paul Kumeta RSS

    How do I colour certain sections on a line graph if dates are grouped by MonthStart?

    Paul Kumeta

      Hi,

       

      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.

       

      Can anyone help me colour different dates ranges still using MonthStart?

       

      Thanks in advance,

       

      Paul