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.
If 2016 is the only line in the chart then it stops at July. When I add another year then it continues to December but shows zero for Aug - Dec.
This expression returns no line at all.
If I change it to > or < then I get the same line as before. Number through July and then drops to 0 for the rest of the year. I just want it to stop at July.