Time Series Data Layout

Omniscope makes use of repeated observations over time in vertical rows, rather than horizontal layouts often used in spreadsheets. To create a multi-line time series, in Omniscope, put your data in the following 'vertical' format:

In this example of a time series, we have 5 companies "A" to "E" with historic share prices for each month. Each record in the data file is a price/time point for a company. The Company field contains Category values correlating to different lines in the time series. Let's call this our Category field. The Month field contains Date and Time values representing the time part of the time series, along the X axis. Let's call this our Time field. The Price field contains quantitative Decimal number values for the Y axis. Let's call this our Value field. Don't worry about the vertical repetition in the data...this will be invisible in all views except the Table View and not evident in the time series reports you configure.

Check your data types- After importing your data, make sure the Time (here Month) and Value (here Price) fields are the correct format. They must be numeric (decimal or integer), or dates, shown by the red to green colour gradation. Also make sure the Category field is of type Category, shown by the variety of different colours. You can convert data from one type to the other by right-clicking the column header in the Table View and choosing Convert field data type.

My data goes the other way!

Sometimes source data is laid out horizontally when Omniscope would manage it better vertically (e.g. time series), and vice-versa. Sometimes data needs to be exported from Omniscope transposed to an orientation different from that used in Omniscope reports. To avoid the time consuming process of changing the orientation of data from horizontal to vertical (row becomes column) or vertical to horizontal (column becomes row), Omniscope has both a De-pivot and Re-pivot function. Use of these functions is discussed in more detail here.

For a continuation on displaying line graphs like time series, see the the Graph View section displaying time series.

Back to Configure your data