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.
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.