Cockpit: "Condition Overview"

Detect conditions such as anomalies, gaps, outliers, or repetitive values and get an overview of user-defined conditions, e.g., scripted ones. Inspect the distribution of such conditions and relate them across time series.

Pro This cockpit is only available in Visplore Professional.

Overview

This cockpit provides an overview of the distribution of conditions like data quality issues. Time series are organized hierarchically and sorted by problem frequency. Different views allow you to effectively capture the distribution of conditions with respect to time or categorical aspects, and to efficiently check them in detail in time series representations. With a single click, you can also select all time periods where all time series are free of any conditions like quality problems, to export this "clean" part of the data for further processing.

  1. Condition Overview: Hierarchical overview of condition "indications. Click the names of time series whose indications should be shown in detail in other views. Several expandable columns provide an overview of the distribution.
  2. Drill Down: The indication count of the currently selected time series is aggregated by time intervals or categories. Time ranges can be selected, which also limits the counting of indications in the "Condition Overview" to the selected ranges.
  3. Time Series: The selected time series are displayed here. Moreoever, the value distribution of the selected time series is shown as histogram, scatter plot, or parallel coordinates view, depending on the number of selected time series.
  4. Table: A table-like view of single values that can be shown on demand.
  5. Check Editor: Create new checks for conditions for the selected time series interactively, and adjust check parameters like thresholds.

Role Description - Starting the cockpit


The following roles can be given to data attibutes in this cockpit. Use the icon in the toolbar to adjust them.


Condition Overview


This view is the centerpiece of the cockpit, and provides a global overview of conditions like data quality issues for all time series. It is visually similar to a table: each row represents one time series or group of time series, and columns summarize the indications of these time series in different ways:

Rows: The rows in the Condition Overview correspond to a hierarchy of time series. Leaf nodes of the hierarchy always refer to individual time series, while higher-level nodes (e.g. the "Total" line in the image) combine multiple time series. By expanding hierarchy nodes, the user can choose any level of detail.

Columns:Columns in the Condition Overview visually summarize the indications of the time series per row in different ways. Examples are the proportion of time points affected by indications ("Frequency"), the distribution of indications over time ("Distribution over Time") or over categories ("Categorical Distribution").


Drill-Down


The views can be used to perform selections of categories by clicking the category labels, which defines a focus for the other views. If a focus was already defined in other views, the Drill-Down views only consider the data records of the Focus.


Time Series


Note: As long as no time series selection has been made in the Condition Overview, these views are not displayed.

The Time Series and Time Series (stacked) views show time series that were selected in the Condition Overview by clicking on rows. The former distinguishes the selected time series by color, the latter highlights the indications selected in the overview using colors. This can be used for a detailed examination of the indications in the context of the time series values.

Time Series (stacked) shows up to five selected time series next to each other. If more than five time series have been selected, the five time series with the most indications are displayed.

Both time series view types offer several options when clicking the view titles. The most important ones are:

Histogram, Scatter Plot, Parallel Coordinates: One of these is shown at a time, depending on the number of time series selected in the Condition Overview - visualizing the value distribution of the selected time series.


Check Editor


Provides a user interface to create new checks for conditions, for the currently selected time series. Time series to create checks for can either be selected in the Condition Overview, or in the Check Editor, via a click. Selecting multiple time series at once allows to create checks for all of them at once. Selecting multiple checks of the same type allows to change their parameters at once.

X: The x icon below the view title "Check Editor" clears the selection of time series. This is useful to see all checks for all time series again in the list. The list can also be filtered by typing text parts in the search bar above the list.

Create new: create new checks for the selected time series. Depending on the choice of check type, default parameters are chosen that can be changed below in the "Properties of the selected checks" pane.

Apply to: After selecting an existing check, this button lets you apply the same check to one or more other time series.

Clone, Delete: use the icon buttons next to "Apply to" to clone a check (e.g. multiple different thresholds) or to delete it.

Properties of the selected checks: various check types have parameters. In this pane at the bottom of the interface, you can change parameters of the selected checks.



License Statement for the Photovoltaic and Weather dataset used for Screenshots:
"Contains public sector information licensed under the Open Government Licence v3.0."
Source of Dataset (in its original form): https://data.london.gov.uk/dataset/photovoltaic--pv--solar-panel-energy-generation-data
License: UK Open Government Licence OGL 3: http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
Dataset was modified (e.g. columns renamed) for easier communication of Visplore USPs.