Contents x
      AddForecast
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      AddForecast

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Calculates average for a specified range and extends it out over a specified number of rows

      Purpose

      Use this function to:

      • Calculate a forecast line from an incomplete data set
      • Calculate sales forecasts


      Parameters

      ParameterDescription
      Column NameThe name of the output column
      Data ColumnThe source column to use when calculating the AddForecast
      Plot Axis0 / 1. Y-Axis to use when plotting graph. Default = 0
      Plot AsBar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose
      Determines the graph style for the output column.
      PlotY / N. Specifies whether measure’s output column should be plotted on graph. Default = Y
      Popup ModeDefault / None / Extended
      Prefix£ / $ / E / %
      Extending Method

      Required.

      Determines the method that is used to extend the dimension column 

      i.e., the X Axis for the resulting graph

      • Row :  Dimension column is extended by filling in with the row number for the required number of rows. 
      • Incrementing Integer :  Dimension column is extended by starting at 1 and incrementing for each added row
      • Decrementing Integer :  Dimension column is extended by starting at -1 and decreasing for each added row
      • Incrementing Date :  Dimension column is extended by adding dates to the last date
      • Decrementing Date : Dimension column is decreasing by adding dates to the last date.   Note this usually means that the forecast line will reverse on itself.
      Required Rows

      Required.

      Default = 90.

      Examples

      Decrementing Date


      Row


      Was this article helpful?
      What's Next