How to import time series data

If you have data that has a column with dates and a column with numeric data, Silk will recognize it as time series data before importing the data. After importing, Silk will plot the numeric data on a time series chart.

Here is an example dataset that Silk recognizes correctly:

DateCoffee
2016-01-01142
2016-01-3197

You can also add multiple dates, if you add another column that tells where the number belongs to. Take this dataset for example:

DateCoffeeDepartment
2016-01-012Design
2016-01-01142Engineering
2016-01-3125Design
2016-01-3197Engineering
2016-02-20120Engineering
2016-02-2010Design
2016-03-31160Design
2016-03-3120Engineering

Silk will turn this data into this chart:


Since this dataset has multiple entries on the same date, it will show a line for the design department and one for the engineering department.

In short: