Creating a Timeline Chart

Overview

A timeline chart visualizes data trends and changes over time.

Timelines groups data based on a field representing date or time. This can include:

• Date field (e.g. 2014-01-01)
• Date-time field (e.g. 2014-01-01 00:00:00)
• An integer field representing a year (e.g. 2014)

Creating a Timeline Chart

To create a new timeline chart:

1. Navigate to File > New View.
2. Select the appropriate data source and table. Make sure the table has at least one date, date-time, or integer field.

   

3. Give the view a name and select Chart - data visualization view.

   

4. Select Timeline.

   

The new timeline chart will default to grouping the data with the first date, date-time, or integer field available in the data.

Select the following to define the timeline chart:

1. Date/Time field - defines the x-axis of the timeline.

   Note: to use an integer field as a Year grouping, click 'Select a Year Field' at the bottom of the drop-down enable picking integers as options.

   

2. Grouped by - groups the values along the x-axis. Options are:
   • Year
   • Quarter
   • Month
   • Week (Sunday)
   • Week (Monday)
   • Day
   • Hour
   • Quarter Hour
   • Exact Time
   • Group into Bins
3. Secondary Category field - (optional) groups the values further.
4. Value fields - populates the values in the timeline. Select value fields by dragging them from the Available Fields into the Value Fields section.