Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am accumulating one of my expressions 4 steps back and then dividing it by 4 to get the 4 weekly rolling average. However the first 3 weeks of the chart are obviously misleading because there isn't enough data. How can I ensure those first 3 values are not plotted?
You can't with using the accumulation option of the chart. You could try setting the background color to 100% transparant, but you'll still see the dates on the x-axis. Or you can use an AsOf table as explained in this document: Calculating rolling n-period totals, averages or other aggregations
You can't with using the accumulation option of the chart. You could try setting the background color to 100% transparant, but you'll still see the dates on the x-axis. Or you can use an AsOf table as explained in this document: Calculating rolling n-period totals, averages or other aggregations