Adding a Trend Line
A trend line is a straight line that connects two or more points and then extends into the future to act as a line of best fit or regression line.
Prior to version 3.0, to add a trend line, you need to add a line chart to an existing chart using the Trend and Forecasting function. Starting in version 3.0, to add a trend line, you can right click on your existing chart (either in edit or view mode), and select the new "Add Trend Line" option.
2. Data preparation
Sample data: Stock (monthly average) closing value as measure and date as hierarchy.
Data when viewed as a chart (e.g. using a Curved Line chart):
3. Add a Trend Line
- In the dashboard editor, or while viewing the dashboard, right-click on the data visualization and select "Re-Visualize"
- Select "Add Trend Line"
4. Data Analysis Panel
If you check the Data Analysis Panel, you will notice that one additional measure representing the trend line was created.
The formula generated uses the Trend and Forecasting function:
5. See also