Grid, Pivot Table, and Text Controls

Overview

Grids, pivot tables, and text content fields create the dashboard other components. These elements are used for displaying data in a table format, and adding any type of text or image into your dashboard applications.

Grid

Grids are tables that show data in a list format. You can choose from all available data fields and show them on a grid. Click a data field to change its expression or add conditional formatting, after selecting it in the Grid Columns.

Pivot Table

Pivot tables allow you to summarize data in an organized table format. They are also useful for comparing data fields side by side. Pivot tables come in two forms; classical and tree.

Tree pivots use only Row and Measure fields. If you select more than one input for either the Row or Measure, the table will add buttons to allow for expanding the rows. The hierarchy will be formed based on the order you add the data to the Row and Measure fields.

Classical pivot tables accept one Column field and any number of Row and Data fields. If you select more than one input for either the Row or Data, the table will add buttons to allow for expanding the rows. The hierarchy will be formed based on the order you add the data to the Row and Column fields.

With both table styles, you can also select an Expression, assign Conditional Formatting, modify the Titles, or change number Formatting for the Measurefields by clicking the corresponding selected fields.

Classical Pivot	Tree Pivot

Text

Text modules help add labels like headlines, explanations, or other text fields into your dashboards. The Content section provides a simple text editor where you can enter and configure the text to be displayed.

The Layout tab contains options for customizing the Background Color, Border Color, Border Thickness, and Border Type properties. These settings will affect the text area box.