Cockpit: "Summaries"

Interactively build pivot tables from variables, visualize as bar-charts, line-charts etc. Define ad-hoc summations and assess distributions as box plots.


  Video available: The easiest way to get acquainted with the workflow of this cockpit is to watch the video tutorial in our Video Academy

Overview

This cockpit allows you to aggregate one or more variables for any combination of categories (e.g. averages, sums, etc. per month, day of week, year, etc.). The aggregates per category are displayed as table, bar charts, line charts, etc.. By selecting multiple variables, it is possible to interactively create totals of the variables, for example to try out how the grouping of the variables affects the total sum (e.g. of output or production). The aggregates can be exported in various formats for further processing with one click.

  1. Select variables to be aggregated in the Pivot summaries, and displayed in the other diagrams.
  2. Summaries of the selected variables: Views that aggregate the values of the selected variables by categories and display them as table, bars, line charts or box plots.
  3. Drill Down: In this cockpit, mainly used to select categories or time periods that should be the basis for the summaries.
  4. Time Series: Time series plots of the selected variables with the possibility to select records, and to zoom to selected time ranges.
  5. Table: A table-like view of single values that can be shown on demand.



Select variables

A list of all variables, with the main purpose of selecting variables to be shown in the other views. The list can be filtered to those containing a certain text. The list can be ordered by various statistics by clicking on a column header.


Summaries of selected variables

These views show statistical summaries of the selected variables, considering the data records that are in focus. All views allow further subdivision by categories, to interactively build pivot tables, bar charts, etc. with a single click.

Exporting: A key use case of these views is exporting the underlying pivot tables. To export the current view as table, click on "Export" in the top right of the view.


Drill Down

These diagrams initially display the mean value of one selected variable per category, using colors. Each colored cell (or bar) aggregates the data that falls within the corresponding (combination of) categories.

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.

Instead of showing the mean value of a selected variable, a drop-down menu available when hovering the color legend allows to choose to color by different statistics.


Time Series


These plots show variables over time. If the time axis has a regular raster, the timeline is connected as line graph. If more than one variable is shown, there are two ways of distinguishing them:

Key actions:

The diagram offers several options when clicking the view title "Time Series". The most important ones are:


Table ('Focus data records')


A table showing the single values. Only considers the data records in focus. Click the header of a column to sort the table by it. To change the set of displayed columns, click the header "Shown: 103 of 210 data attributes". Click single rows or drag a line with the left mouse button to select records, putting them into focus.

Exporting: A key use case of the table is exporting a selected subset of the data. To export the current state of the table, click on "Export" in the top right of this view.


Roles supported by this cockpit

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



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.