What is a grid table
Grid — a visualization type that allows to view the raw data in the flat or record-based format where each parameter is a column and each record is a row.
A grid table contains a set of data that is structured in rows and columns. It allows a user to scroll in both directions and can handle large numbers of items and columns. Comparing items is a major use case - a grid table might be more appropriate than a responsive table. In the grid table each cell contains only one data point. Note that the grid table provides only one level of grouping.
A grid table is only available for flat datasets, you will see its presence among other available charts:
How to build a grid table
- Open a flat dataset in the dataset viewer.
- Select needed subset of data using dimension filters at the left (to show the whole dataset, select all members in any dimension)
- Switch to the grid table view in the right panel. If you will select only one indicator in all dimensions, the grid table will be automatically created:
There are two views of the grid table: grid and passport. Click on the grid table icon again to switch to the passport view (single-row view). Click once again to return to the grid view (or, you can use an icon at the bottom right):
How to customize the appearance of a grid table
There are not many appearance settings for the grid table - you may only customize it’s color scheme, font size and type and hide extra columns you do not need.
1. To adjust the appearance of the grid and (or) save it, open it in a new dashboard:
2. Go to the editor mode of the gadget and switch to the Appearance tab (select the hamburger menu on the gadget in the upper right corner of the graph image and select Edit).
3. In the "General" section, you can set colors, precision, font, and alignment of the table.
4. You can also change the width of columns. To do that, save the gadget, and resize the column by dragging-and-dropping the border of the column.
Please, note that you can change the order of columns but it will not be saved. There is no possibility at the moment to reorder columns.
How to hide columns in a grid table
As a rule, flat datasets have a lot of columns in them and sometimes, you may not need to show all of them at once. So, there is a possibility to hide unnecessary columns.
To hide columns, go to the "Columns" section in the appearance tab of the gadget editor and remove the checkmark of those columns you do not need to display:
Choose needed column and turn off it’s visibility: