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.
This page covers the following subtopics:
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:
|Panel Type||Data Accepted||Customizable|
|View Stream as Table||All||Yes, in terms of preset table styles.|
|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: 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).|
|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.|
To develop panels, you first need to be sure that you have the right data. If you are using s-Dashboard with StreamLab, this means moving back and forth between dashboards and StreamLab. If you are using s-Dashboard directly with s-Server, this may involve creating new views on the data in s-Server (or having a SQL developer create such views). Once you get the right data flowing into your panel, you may also want to adjust how that data flows (in terms of how many rows appear at once, for example). Finally, you can customize the appearance of the panel itself.
The first step is to make sure that s-Server has the stream, view, or table that you want to display, and that this object has the right data. For example, most panels require numerical data, and if your stream, view, or table doesn’t have numerical data, you will not be able to use s-Dashboard’s graphic visualizations (though you can still display this data in a table).
To confirm that your stream, view, or table has the right data, open s-Dashboard and use the Select Input dialog to open the stream, view, or table:
If you open a visualization, though, you may find that the data doesn’t suit your visualization: “loginFailureCount” and “amount” seem right for a dials display, but not “accountNumber” or “lat” or “lon.” (On the other hand, these values might be just fine for a Geographical Stream panel.) One solution is to create a new view in s-Server with only the two desired columns, as in the screen shot below. (You may need to work with a SQL programmer to create this view.)
You can learn more about views in the CREATE VIEW topic of the SQLstream Streaming SQL Reference Guide.
Basically, though, views are reusable SELECTs on a stream. The view depicted above looks something like this in SQL:
create or replace view "MOCHI"."SuspectDebitOverview" as SELECT STREAM "amount", "loginFailureCount" from "MOCHI"."SuspectDebits";
After you get the right data flowing into a panel, you can customize the panel’s appearance by using the Panel Preferences dialog box. Changing Panel preferences is a key part of getting your panels to look right. Some panels let you make relatively minor changes, but in some cases, preferences let you customize the entire look and feel of the panel.
To open the Panel Preferences dialog box, click the Panel Preferences icon in the upper right corner of the panel.
The options available here will change depending on the type of panel selected. For Table, the Panel Preferences dialog box lets you set the number of rows displayed, the table’s style, and whether or not the table scrolls, among other options.
Using the Input Preferences panel, you can specify how much data to show. This might be twenty rows at once, all rows from the past hour, twenty rows per key category, and so on. See s-Dashboard Input Overview for more details.
Once you get the data right, your next step is to customize the panel. The View Latest Row: Bar Chart, for example, lets you change the colors of the bars, bar border, and hover color. (You can do much more by taking advantage of Chart.js.)
You should experiment with Panel Preferences to get your desired effect. See Using Panel Preferences below for more details.