Previewing tables and fields in the data model viewer
In the data model viewer, you can preview any data table in the panel at the bottom of the screen. In the preview, you can quickly inspect the contents of a table or field. You can also add dimensions and measures to the app if you select a field.
Additionally, metadata for the selected table or field are displayed in the preview panel.
You can show and hide the preview panel in two ways:
- Click in the toolbar.
- Click the Preview header.
Showing a preview of a table
Do the following:
- Click a table header in the data model viewer.
The preview panel is displayed with fields and values of the selected table.
Showing a preview of a field
Do the following:
- Click a table field in the data model viewer.
The preview panel is displayed with the selected field and its values, and metadata for the field. You can also add the field as a master dimension or measure.
- Density is the number of records that have non-NULL values in this field, as compared to the total number of records in the table.
- Subset ratio is the number of distinct values of the field found in this table, as compared to the total number of distinct values of this field in other tables in the data model. This is only relevant for key fields.
- If the field is marked with [Perfect key], every row contains a key value that is unique.
To learn more about creating a master dimension, see Creating a master dimension from the data model viewer.
To learn more about creating a master dimension, see Creating a master measure from the data model viewer