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)
   • Date
   • 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.

Display Options

There are additional display options available to any viewer of the view, available in the view's header:

If you change the display options on the view you've written (e.g. setting the view's type to Bar or Line), you will set the default for anyone who sees the view. For more information on those options, see Using a Timeline Chart.

⇦ Visualization

⇧ Table of Contents

⇨ Using a Timeline Chart