Add a Trend Value Column to a Report

Trend value computed fields are similar to comparison value computed fields. However, where comparison value columns return data from previous time periods, trend value columns return forecasts of data in future time periods, calculated from current data.

Trend values are best used when trending a column that groups data together by a time period, such as a column that shows the number of incidents created in the same week.

Tip: You can also add trend value columns by clicking the column you want to trend on the design surface, clicking the Design tab, clicking the arrow on the Insert Column button, and then selecting Trend Value.

1. Add a numeric output column that returns values you want to trend.
   For example, if you want to forecast the number of incidents that will be created in future weeks, you could add a column for count(incidents.i_id) to return a count of incidents.
2. Expand the Computed Fields tree in the data dictionary.
3. Click the column you want to trend.
4. From the right side of the data dictionary, drag the Trend Value column name and drop it on the design surface.