Data grid tiles

Being able to see individual or groups of records is an essential feature in FastStats. You can achieve this in Orbit with data grid dashboard tiles. The data grid tile allows you to choose a table, and columns from this table and its parents. You can choose to view the results as a grid view or a page view. Grid view works well for multiple records while page view works well for single records. You can select multiple records and filter, sort, and search the rows and columns.

Creating a new data grid tile¶

To add a data grid tile to your dashboard:

1. Select the Data Grid tool from the chart type options.

2. Click + Add Column.

3. Select your variables or use an expression.

4. Choose a Table from the data display records.

5. You are only able to choose columns from the current table.

Orbit adds one column by default, and you can add and remove subsequent columns. You can choose whether to show codes or descriptions for the data in these columns, if the data supports that.

Data grid views¶

You can view the data as a Grid view or a Page view.

Grid view¶

A Grid view shows multiple rows of data.

Page view¶

A Page view shows one record per page.

Sorting and filtering columns¶

Click a column header's options menu to sort the column, and to filter it if it's a text, numeric, or date column.

• Text: filter by Contains or Does not contain, then enter your search text

  

• Numeric: filter using a comparison such as Is equal to, Is not equal to, Is greater than, Is greater than or equal to, Is less than, or Is less than or equal to, then enter a value

  

• Date: filter using a From and To date range

  

Sorting applies as soon as you select it. For a filter, enter your criteria then click Apply. Click Clear to reset both the sort and the filter.

You can add records to the filter by selecting the row or column and clicking Add to filter.

You can then export the retrieved records to PDF or Excel. Click Export Chart from the options menu.