Each of your dashboards can contain multiple query panels. You can easily customize the structure of your dashboards and arrange your query panels in various ways to make them more readable and user-friendly.

To set up and create a dashboard, open a Data Table and in the upper-right corner click Create Dashboard.

Dashboard Layout

When you create a new dashboard, you can choose a layout for query panels on your dashboard. The structure of a dashboard is based on a classic 12-column grid system where you have multiple rows split into 12 columns. In other words, a ‘-’ means a vertical split, and a ‘/’ means a horizontal split.

Let’s look at an example: the following screenshot shows a dashboard with the 12/6-6 layout. It means there are two rows, with the top one taking all the space (12 units), and the second row split into two columns (6 units each).

As you can see, we have got the main datasheet in the top row (taking up the entire 12-unit width), and two columns in the second row (6 units each). The column on the left contains a query panel that is outputting a bar chart, and the column on the right contains a query panel that is outputting a pie chart.

Currently, the following layout options are available:

LayoutExplanationVisual Representation
6-6One row split into two equal columns.
4-8One row split into two columns, with the first taking 1/3 of the space, and the second one taking 2/3 of the space.
12/4-4-4Two rows with the full-width top row and the bottom row split into three equal columns.
4-4-4/12Two rows with the top row split into three equal columns, and the full-width bottom row.
12/6-6Two rows, with the full-width top row, and the bottom row split into two equal columns.
6-6/12Two rows, with the top row split into two equal columns, and the full-width bottom row.
12/6-6/12Three rows, the first of which is full-width, the second is split into two columns, and the third is full-width.
3-9 (12/6-6)One row split into two columns (3-9). The second column has two other rows nested inside (12/6-6).

 

Editing an Existing Worksheet Structure

By default, your dashboard contains one query panel. It is a table from which you created the dashboard. However, you can add more query panels depending on the chosen layout. To add and configure queries and query panels, you need to activate the Edit Mode. If you do not see the button for Edit Mode, it means you do not have the correct permissions to change the dashboard and need to contact its owner.

In the edit mode, you can move your existing query panels within the dashboard and add new queries. This is the structure of the example dashboard that was presented above. It has three query panels with the 12/6-6 layout. To add a new query panel to this layout, click New Query.

To choose another layout, you need to exit the edit mode by clicking Save or Cancel, and then click Settings.

Arranging the Query Panels

In addition to changing the overall dashboard structure, you can change the position of your query panels on the page. To do it, activate the edit mode and drag each of your query panels to another part of the structure by using the icon.

More than one query panel can occupy each cell of your structure, for example, like this:

And here is the final look of the dashboard with rearranged query panels: