Working with datasets and schedules

Datasets and schedules are inputs to your jobs. See more about working with time series.

Datasets

To add a dataset go to the relevant project, scroll to the bottom and click on the Add Dataset button on the right. Click Upload csv.

You can click to go to a file browser or you can drag-and-drop the csv-file. The csv-file can be nearly any type of time series data. Here is a sample file (opens in a new tab).

File format

You can include as many data columns as you need in the csv-file.

It is optional to include a time series (time) column. If you don't include a time column then numerous will assume equal spacing between timesteps in seconds, minutes, hours, days, months or years.

If you include a time column then it should be the first column, it should start at 0 (zero) and be an integer measured in seconds.

Managing the dataset

Dataset name
Choose a name for the dataset. The default is the filename.

Include columns
Choose which columns to include in the dataset. The default is all columns.

Index column
Choose between "Standard index" which will add a time column to the start of the dataset or choose a column to be the time index in seconds.

Time interval between rows
If you chose "Standard index" as the Index column, you can choose the interval between rows in the dataset. The time column is measured in seconds.

Start date
Start date for the dataset. Date and time for index 0 (zero).

Absolute time range
The timeline shows the time range for the dataset after setting the time index column and the start date.

Schedules

With schedules, you can set a weekly timeline, that can be used to activate different functions in your code. You can use schedules to set specific time intervals between querying data from outside sources or it can be used to manipulate time series data in general.

To add a schedule go to the relevant project, scroll to the bottom and click on the Add Dataset button on the right. Click *Add schedule.

If there is an existing schedule on the project, you can also go to the schedule, click on the three dots and click Add schedule.

Edit dataset or schedule name

To edit the name of a dataset or a schedule find it on the project. Scroll to the bottom and click Show. Click on the three dots on the dataset or schedule you are looking for and click edit name.

Delete dataset or schedule

To delete a dataset or a schedule find it on the project. Scroll to the bottom and click Show. Click on the three dots on the dataset or schedule you are looking for and click delete.