Previewing Data from a Table
The Preview table lets you see all the values for all the rows and columns in a table. This includes any custom columns, tables, and ETL processes that have been applied to your table.
The Preview table makes it easy to verify that the data in your table is accurate and complete.
In addition to displaying a preview of your data, from the Preview table, you can view which columns are connected to other tables and add custom columns.
Note: To view underlying table data, you will first need to build your ElastiCube.
To review the underlying table data:
The Preview table contains a variety of information and functionality that relate to your table. A sample preview is displayed below.
|1||Column Filter||In the left pane, you can search for columns in your table. As you begin to type, any relevant results are displayed in the left pane. This does not affect the results displayed in the preview.|
|2||Connected Table||This icon indicates that the column is connected to another table. Click the icon to disconnect the relationship or to view more information about the connection. See Creating and Removing a Relationship between Tables for more information.|
|3||Table Details||This information describes the number of columns and rows included in the table.|
|4||Menu Options||This is a list of tasks you can perform on a column. Hover over the column to display the menu and click it to display the options.|
|5||Filter Column||Click to apply filters to the data in the column. You can filter numeric data and text data. See Filtering Columns for more information.|
|6||Sort Column||Click to sort a column. Hover over the column name to display the sort icon. You can sort the column by date, numerically, or alphabetically depending on the type of column.|
|7||Add Custom Column||Click to add a custom column to the table. See Adding a New Custom Column for more information.|
|8||Sample Data||Click to see a sample of your data. See Sampling Data for more information.|
You can filter data displayed in your Preview table’s columns by defining conditions for numeric data and text data. To limit what data is displayed in the preview, you can add multiple conditions that you define. For example, a Text filter can limit what strings are included in the preview.
Filtering the data in the Preview table does not affect the data itself, just what you see in the preview.
Filtering your preview is useful if you need to check specific data to verify its accuracy of your table’s completeness.
To filter entire rows or columns of data from your preview:
- In the Preview table, hover over the header in the of the relevant column to display the Filter icon.
- Click the Filter icon to define the filter’s conditions.
- Define your filters. Click Add Condition to add more conditions to the filter or click Clear to erase all the conditions.
- After you have defined your conditions, click Apply to update the preview.
If you are working with a large dataset, you may want to restrict the amount of data displayed in your Preview table. Sisense provides three options for displaying a sample of your data:
Top: The first rows that are contained at the top of your data.
Bottom: The last rows that are contained at the bottom of your data.
Sample: A random selection of rows contained in your table. Sisense selects a sample of your data randomly by rows. If you open the preview again, the same rows will be displayed until your next ElastiCube build.
With each sampling option, you can determine how many rows are display according to the value of the Number of Rows field. You can modify this value to display as few as 10 rows or include as many as you like up to the full amount of rows included in the table.
To view a sample of your data:
- In Sisense, open a preview of your table.
- In the top-right corner of the Preview table, click the Sampling Icon.
- Select the relevant sampling option for your data and enter the amount of rows to be included in the sample in the Number of Rows field.
- Click Done. Your Preview table is updated.