Introduction

Astrato’s customization options can turn your basic Table into - well, 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.


Contents

  1. Table Types

    1. Selecting a Table and applying styles

  2. Using Pivot Tables

    1. Labels - show or hide

    2. Conditional formatting, changing styles


Table Types

  • 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

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

  2. From the Object panel on the right, the Data tab displays, click Column to add the first measure or dimension for your table.

  3. Click on the Style and Layout options to view and apply the customization properties.

The animated GIF shows the steps to add a table to a worksheet and amend formatting and style.

Figure 1 shows a table being added to a worksheet.

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 now view cross-sections of data with first and second layer data filters.

Labels - show or hide

Each measure in the properties panel has an 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.

The screen shot shows a pivot table and different types of conditional formatting.

Figure 2 shows a pivot table and different types of conditional formatting.

Back to Top

Did this answer your question?