Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Trend Lines are lines that connect two or more points and then extend into the future to assist in detecting and predicting trends in time-series data. To display Trend Lines select [Analysis > Show Trend Lines]. Trend Lines display as black lines overlaid on the current view and are dashed when shown over Line Charts and solid when shown over bar charts to prevent confusing them with original chart content. You can also edit Trend Line Options with [Analysis > Trend Lines > Edit Trend Lines...] when [Analysis > Trend Lines > Show Trend Lines] is enabled. 

Info

Download and connect to the sample data source

Image Modified

Once a Trend Line or Lines are displayed you can view slope and y-intercept for all the displayed Trend Lines by selecting [Analysis > Trend Lines > Describe Trend Model...].

Image Modified

If there are multiple lines, it is possible to show individual Trend Lines per line color by selecting [Analysis > Trend Lines > Edit Trend Lines...> Allow a trend line per color].

Image Modified

Once [Allow a trend line per color] is enabled in the Trend Options dialog, each Trend Line will have a dashed line the same color as the line it is trending to make identifying them easier.

Image Modified

If Trend Line Per Color is enabled for a Multi Line Chart, selecting [Analysis > Trend Lines > Describe Trend Model...] will produce Trend Line Details for every Trend Line visible in your chart. 

Image ModifiedVisual Analytics -

Anchor
Edit Trend Line
Edit Trend Line

...

Edit Trend Line Options

You can select Trend Line options by choosing [Analysis > Trend Lines > Edit Trend Lines...] which launches the Trend Line Options dialog.

...

  • Linear
  • Logarithmic
  • Exponential
  • Polynomial, degree (and choose the value for degree)

Image Modified

Options within the Trend Line Options dialog also allow for

  • including fields as factors (with the Dimensions listed from your decks)
  • enabling/disabling trend line per color
  • showing confidence bands
  • forcing y-intercept to zero.

Image Modified

Image Modified
If you plot chart using a trend line and select specific data points in the view, Visual Analytics compares the data for the selected data points and plots a recalculated line for the highlighted data while dimming the original line.
 
The following example originally showed order date by freight. When you select October through December, Visual Analytics instantly compares the order date for these months and plots a recalculated line for the same. Now you can view freight for the last three months to the overall total quantity ordered new for each customer segment.

...