Skip to main content

Static Grid Charts

Sometimes multi-series charts can become very cluttered and you might wish to keep them separate and yet do it within a single visual. Static grid charts can be used for this where a set of charts can be organized in column, row or grid layout. These are called static grids since the number of sub-charts in them is only dependent on the configuration and not the data.

Column layout

When there are multiple data series along an axis, they can be displayed as separate charts placed side by side as columns. One advantage of this is highlighting a data point in one of the charts automatically highlights related data point in the other. Try clicking one of the bars below to see this in action.


Row layout

They can also be organized one below the other as rows.


Grid layout

When there are multiple dimensions along both the axis, then the column and row layouts can be combined to create a grid layout. This allows the ability to display different levels of details concisely in a single chart. In the following example, the data can be studied both at the island level of detail as well as sex level of detail.

Multiple LOD charts

Note that it is possible to use multiple levels of detail from the same DataFrame because SQL Frames supports the cube SQL construct. The power of expressing complex data transformations in SQL Frames makes it possible to create powerful yet low-code integrations.

Multi-series static grids

asCols(), asRows() and asGrid() used above are low-code convenience APIs. It is possible to have more control on the static-grid layout in terms of which data series is placed where using the colIndex and rowIndex fields of the data series. Hence each cell within a static-grid can itself be a multi-series chart.