8 Replies Latest reply: Aug 2, 2016 3:23 PM by Mark Ritter RSS

    End Line at last month/year of data

    Mark Ritter

      I have a line chart with 3 years of data.  The years 2014 and 2015 are full years.  The year 2016 only has data through July. 

       

      Do I want the line for 2016 to stop at July and not drop down to 0 for the rest of the year.

       

      Not sure how to accomplish this.

       

      This is the expression I was trying.  I hard coded the month just to see if it would work.  It didn't.

       

      Sum({<Year={'2016'},Month={"<=7"}>}MEDARev)