Archive for April, 2018

sqlDashboards adds Step Plot Visualization

Our standard time-series graph interpolates between points. When the data you are displaying is price points, it’s not really valid to always interpolate. If the price was 0.40 at 2pm then 0.46 at 3pm, that does not mean it could be interpreted as 0.43 at 2.30pm. Amazingly till now, sqlDashboards had no sensible way to show taht data. Now we do:

Step Plot of Asset Price

For comparison here is the same data as a time-series graph:


The step-plot is usable for time-series and numerical XY data series. The format is detailed on the usual chart format pages.

sqlDashboards now supports Stacked Bar Charts

sqlDashboards has now added support for stacked bar charts. e.g.:

Stacke Bar Chart of Exchange Volumes

The chart format is: The first string columns are used as category labels. Whatever numeric columns appear after the strings represents a separate series in the chart. Row in the table is shown stacked above the other, in the order as they appear.

e.g. The table for the above chart is:


sqlDashboards supports Graphs,Nodes and State Diagrams

sqlDashboards is specialised for real-time data visualization. Often this includes monitoring the state of orders, whether that’s baskets of goods being ordered online or financial transactions, we want to help you see what state those items are in. To support visualizing this data we’ve integrated the most powerful open source graphing: DOT and graphviz. If you install graphviz and make it available in your path, you can automatically get sqlDashboards to generate graphs from tabular data, like so:

From To label cnt
PendingCancel Calculated Rejected 50
PendingReplace Calculated Rejected 10
PendingReplace Calculated Replaced 40
Calculated PendingReplace PendingReplace 50
Calculated Filled Trade 9400
Calculated Calculated Trade 5239
PendingCancel Removed Cancelled 150
Calculated PendingCancel PendingCancel 200
New Calculated Calculated 9660
New Removed Rejected 140
Created Removed Rejected 300
Created New New 9800


Notice to get the labels and styling you use a column called label or style respectively. The full format is detailed on the sqlDashboards example page.