Timeline Charts

A timeline chart is a line chart with one axis dedicated to a time dimension. Use a timeline chart to show how a value changes over time.

Create a Timeline Chart

Use a timeline chart to analyze changes to a measure over time using a line.

For example, a timeline chart can show how profit changes over a year. Exploring a year's worth of data, you want to visualize not just the total profit, but how profits change from month to month.

In the lens, click and then select the Timeline chart type.
In Time Axis, select the date field and the granularity that you want to analyze the results by. For example, select Closed Date | Year-Quarter.
In Y-Axis, add at least one measure to analyze over time, such as the total opportunity amount.
If needed, add a filter to restrict the results to a particular time period, like a single year.
The timeline chart analyzes the measures with the time dimension shown along the x-axis.
Note Timeline charts need a defined point in time. If a data point has a null or missing value for its time-related field, the chart can’t place it on the time axis. As a result, rows with a null value in the axis field are excluded.
To change the chart display, click and set the chart properties in the Formatting panel.
For example, if some of the dataset includes predictions of future amounts, click Predictive Line under the X-Axis section in the charts properties panel. Or add a reference line to provide a visual cue about a particular point in time.
To add a reference line, set the position of the reference line by specifying the date in Time.
The numerical date you specify should match the granularity selected in the Time Axis field. For example, if you selected Year-Month and want the reference line to start just after August 2016, enter 2016/8. You can also specify a label in Label for the line, and a color.