3 Replies Latest reply: Jun 15, 2017 10:19 AM by Vasiliy Beshentsev RSS

    coloring lines in chart

    Justin Taylor

      I have a chart that shows a count by month with overlapping years.

      I've been asked to specify the line color by year.

      2015 = blue

      2016 = yellow

      2017 = red

       

      I've been trying to color by dimension and by expression but I'm missing something.

       

      This color by expression gives me yellow for all lines:

      if(Year(Date)='2015'

        ,blue()

        ,if(Year(Date)='2016'

           ,yellow()

           ,red()

           )

        )

       

      If I don't try and specify anything, and color by dimension using   =Year(Date) then this is what the chart looks like.

       

      I could use a little help.  thanks.