Search Results

Data panel

The Data panel provides a structured list of all loaded data columns. Using the panel, you can, for instance, with drag and drop specify which data columns to use on the axes of the visualizations, or you can filter to certain values, because each column in the panel is associated with a filter.

The Data panel is automatically shown when you create a new analysis. You can also click on the Data button, , to show the Data panel when the analysis is in Edit mode.

The columns are by default organized into categories to make them easy to locate. For example, loading the Excel file below results in the Data panel to the right. Columns containing numerical data suitable to aggregate are gathered in the Numbers section, columns related to time are in the Time section, and columns useful for splitting data in the Categories section.

If the suggested category for a column is not the desired category, you can change the categorization.

You can expand the data panel to get an overview of the content in the columns or to get more details about a column by clicking on the Expand data panel for tools and details button, , at the top right of the Data panel. See also Getting an overview of the data.

In the data table view of the expanded data panel, the categorized structure of columns can be changed to a flat list where columns are listed alphabetically. Click the Sort order in data panel button, , and select an Ascending or Descending order. Another option is No sorting.

You can easily change what is shown in a visualization by dragging a column from the panel and dropping it onto a column selector or on a drop target within the visualizations. Moreover, you can use the panel to filter to certain values in which you are particularly interested.