Creating a Timeline Chart

From Explore Analytics: The Wiki
(Redirected from Timeline Chart)
Jump to navigation Jump to search

Overview

A timeline chart visualizes data trends and changes over time.

Timeline candle.png

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.
    New timeline1.png
  3. Give the view a name and select Chart - data visualization view.
    New timeline2.png
  4. Select Timeline.
    New timeline3.png

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.
    New timeline4.png
  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:

Timeline header.png

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.