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.
To search for data in the Grid, enter your search string into the Search... field by the 
menu.
The records in the table will now be filtered by the entered text and the spark charts and aggregations will represent the current sample.
To sort all of the visible records, pick the column to use for sorting and click on 
by the column name.
Options:
- Sort Ascending
- Sort Descending
- Original order
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.
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
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.
Brushing the Spark chart will filter the data and update the view, summary statistics, aggregations, and Spark chart.
- 1.Hover over the chart to see thecursor.
- 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.
The column aggregates and the spark charts will update as the data is filtered to represent the current sample.
Last modified 8mo ago