Explore data with Grid

DEX Grid is great for getting a wide-angle interactive view of the data. This section describes how to search, filter, analyze, and sort data in Grid.

Search data

To search for data in the Grid, enter your search string into the Search... field by the
The records in the table will now be filtered by the entered text and the spark charts and aggregations will represent the current sample.

Sort data

To sort all of the visible records, pick the column to use for sorting and click on
by the column name.
  • Sort Ascending
  • Sort Descending
  • Original order

View aggregation data

At the bottom of each column, you will find an aggregated summary of the column. For example: On categorical columns, the sole option is to see a count of the items in the column.
For quantitative columns, the options are:
  • COUNT: # of items in the column.
  • SUM: sum of all items in the column.
  • AVG: average value of all items in the column.
  • MEDIAN: median value of all items in the column.
  • MIN: minimum value of all items in the column.
  • MAX: maximum value of all items in the column.
These values will be updated after filters are applied to represent the current view of the data.

View summary statistics

The summary statistics bar is located above the Spark chart in the column header and the colors in the bar represent the proportion of valid, invalid, and missing values in the dataset.
To view more detail, hover over the bar until the modal appears:
Summary statistics

View Spark chart

An interactive Spark chart is available in the column header showing the distribution & density of the data. Below the Spark chart you can find the following additional information about the data:
  • For quantitative columns, the range of values will be shown.
  • For categorical columns, the # of categories in the data will be shown.
Clicking on this information will allow you to quickly filter the data using this column
Spark charts
If more than 20 categories are available for categorical data, the rest will show up in a category called Other.

Filter data with Spark charts

Brushing the Spark chart will filter the data and update the view, summary statistics, aggregations, and Spark chart.

To brush a Spark chart:

  1. 1.
    Hover over the chart to see the
  2. 2.
    Hold down your mouse button while dragging that cursor across the range that you want to filter to.
Brush to filter a Spark chart
You can also quickly filter data by clicking on the numerical range or # of categories option below the Spark chart.

Filter data with DEX filters

Grid works with the standard DEX filter panel. Read more: Filter data
The column aggregates and the spark charts will update as the data is filtered to represent the current sample.

Learn more