Search Results

Column view

The column view of the expanded Data panel gives you an overview of the values in a certain column. Here, you can also perform some data preparation and cleansing which can help getting visualizations the way you want them.

In the Data panel, click Expand data panel for tools and details, . Click on a column to the left, to show the column view for that column.

The column view will look different for different types of columns. This example shows a string column.

1. The column name can be changed by clicking on the Rename column button, , and typing the new name.

2. You can click at the link at the top of the column view to go to the data table view, which shows an overview of all columns in the data table.

3. Depending on the data type and categorization of the column you can see different statistics.

Tip: If the statistics section shows a histogram, you can click on the histogram in the column view to add a similar visualization to the analysis.

4. You always have the possibility to change the categorization of the column. A good categorization can help you get better recommendations.

5. The data type can always be changed (but for calculated columns you edit the expression to change the data type rather than using this drop-down list).

6. You may also have the opportunity to change things like the sort order or formatting of the column, or, you may have the option to handle empty values in the column. Which options are available depends on the column type.

7. You can also have access to additional actions that are specific for the data type of the column, such as the Split column action that can be used to split string columns.

8. To the right in the column view you will see the contents of the column, either all values or unique (distinct) values only.