Astrato’s customization options can turn your basic Table into nearly a work of art without changing your source data, using formulas or code.
Customization options allow you to highlight the data, improve your table visualization, and let your data tell the story you need to share.
Straight Table: Each column value is displayed in a separate cell.
Expandable Table: Group columns into expandable hierarchies.
Pivot Table: displays multiple data dimensions (groups columns and rows into expandable hierarchies), with added visual style options.
Selecting a Table and applying styles
From the Visualization section, click on the Data Objects (Data Obj.) icon, and click on the Table icon to drag and drop it onto your worksheet.
From the Object panel on the right, the Data tab displays; click Column to add your table's first measure or dimension.
Click on the Style and Layout options to view and apply the customization properties.
Figure 1 shows a table being added to a worksheet.
You can also select a cell in a table instead of the whole row.
Clicking the cell to select it highlights other linked visualizations ('brushing'). This works in both directions, so you can more quickly and accurately select individual cells within a row.
Using Pivot Tables
Astrato’s pivot table elevates our existing table features, with more grouped dimension values that aggregate across the top and the left-hand side.
The pivot table enables users to display a dimension across the top to create a grid-like table visualization. You can view cross-sections of data with first and second-layer data filters.
Labels - show or hide
Each measure in the properties panel has the option to display or hide the measure label. If there is only one measure, the label is hidden by default.
Conditional formatting, changing styles
The example in Figure 2 shows Column data linked to Area - with Neighbourhood as the first layer with Availability and Price per night as the second layer. Row data includes both bedrooms and bed types.
In addition, visual styles and color to display conditional formatting let you tell more than one story - without any coding or change to source data. In the example below, a progress bar (based on a fixed amount) makes comparing availability easier. And the color-linked conditional formatting highlights price ranges.
Figure 2 shows a pivot table and different types of conditional formatting.