I have set up a trend graph with an expression that calculates a rolling-12 month average, using the formula below. The earliest [Incurred Year Month] 200801. Because you need full 24 months before the expression makes sense, any incurred year month before 200912 is blank, but each blank month still appears on the x-axis.
My goal is to make it so that months 200801 thru 200911 do not even show up on the chart, since it takes up a lot of space. In other words, the left-most date is 200912. Is there any way to cut off these values from the chart?
=if([Incurred Year Month]<200912,'',
rangesum(above(sum([Sales]),0,12))
/
rangesum(above(sum([Sales]),12,12)) -1
)
