5 Replies Latest reply: Nov 1, 2017 12:59 AM by rohit lohani RSS

    Line Chart Current Year Vs Last Year

    munirathnam p

      Hi All,

       

      PFA image.

      I have a line chart showing current year trend and previous trend.

      But the issue is with current year trend. For current year i am taking JAN to OCT but the line is connecting to NOV and DEC with the value 0.

       

      i don't want to connect it to Nov and Dec. i have selected the option "Show as gaps" also still it is not working as expected.

       

      My Expression for Current Year  --  sum({<Year={'$(Max(Year))'}>}values)

       

      Can anyone suggest me how to resolve it.

       

      Thanks in advance.

      Rathnam.