Working with Panels

<< Click to Display Table of Contents >>

Navigation:  Using s-Dashboard >

Working with Panels

Previous pageReturn to chapter overviewNext page

In s-Dashboard, a panel is a visualization object, such as a bar graph or map, that displays data from a stream or streaming view in s-Server. You need to create these streams or views outside of s-Dashboard, either using hand-coded SQL or StreamLab. See s-Dashboard Input Overview for more information.

Panels can read from any stream or view in s-Server or StreamLab, regardless of schema. You can display multiple panels in a dashboard by changing a dashboard's layout. See Creating Dashboard Layouts for more details.

Individual panel types, such as Bar Charts, Dials, Areas, Bollinger Bands, Scatter Plots, and Maps, all have specific data requirements. All panels require numerical data, but some also require ROWTIME, a key column, or latitude/longitude to work. See Table of Panel Types for more details.

Getting the right results in your panels will take some time. See Suggested Panel Development Process for ideas on developing panels.

The Select Panel dialog box divides these into categories according to their data needs:

View Stream as Table

View Latest Row Panels

View Rows Over Time Panels

View Rows Over a Key Column Panels

Geographical Streams Panels

Creating a Custom Panel in s-Dashboard Using Vega

Creating a Custom Panel in s-Dashboard Using Chart.js

Many dashboards are built using either the Vega visualization grammar or the Chart.js Javascript charting. You can create your own panel types using either framework. s-Dashboard provides customizable panels for this purpose.

Table of Panel Types

Panel Type

Data Accepted

Customizable

View Stream as Table

All

Yes, in terms of preset table styles.

View Latest Row

Numerical.

Extensively in terms of appearance. Bar Chart and Radar Chart use Chart.js and have advanced options.

View Rows Over Time

Numerical

Extensively in terms of appearance. Bars Over Time and Radar Chart Over Time use Chart.js and have advanced options.

Areas, Bars, Lines, Scatter let you change color scheme, interpolation (cardinal, linear, step), as well as some other options.

View Rows Over Time: Time Series

Numerical

With Control Panel enabled, can change type and interpolation (cardinal, linear, step).

View Rows Over Time: Bollinger Bands

Columns need to be named avg, avg_upper, avg_lower, avg_upper2, and avg_lower2, where avg is the running average and the rest are the bounds. "avg" can be any prefix.

Can change update frequency, band colors, and interpolation (cardinal, linear, step).

View Rows Over a Key Column

Numerical columns, key column. A key column has a limited set of values, and let you divide your data into categories. This can be a list of cities, departments, countries, regions, products, and so on--any category into which your data can be grouped.

Extensively in terms of appearance. Bars Over Key and Radar Chart Over Key use Chart.js and have advanced options.

Geographical Streams

Need lat and lon columns. For choropleth map of Pan and Zoom, need key and value columns. For Pan and Zoom, key column required for Key Color Map.

For World Events, can change map color scheme and map area covered. Can change diameter, marker icons, event labels, and add key color map for Pan & Zoom Map.