Using DataVis Grids - Data Tools
The actual grid you use may differ slightly in appearance from the examples below. Some grids may be configured specifically to disallow certain features.
The grid starts with “plain output” which shows the raw data. This is useful for examining all the details, and allows you to sort and filter.
initial view of the grid
- Show/hide the whole grid.
- Use the gear icon to show/hide the grid controls (where you can set the filter, group, pivot, and aggregate functions: see following screenshots).
- Select (or deselect) all visible rows. If the data has been filtered, then only the filtered rows will be selected/unselected.
- Click the double-arrow icon to show a menu that allows sorting the data.
- Click the filter icon to add a filter for the column.
- The view toolbar section — use the back/forward arrows to navigate view history, the dropdown to select a view, and the undo button to reset all views.
- The limit toolbar section — initially, only the first 500 rows are shown. More will be shown as you scroll down; the checkbox can be used to turn that behavior on/off. The “Show All Rows” button will immediately show all rows, without having to scroll down repeatedly.
after clicking the gear icon to show the grid controls
- The filter control — here we have filtered by Order ID. To add more filters, select the column name from the dropdown and click the “+” button, or drag the column header into the control, or click the filter icon in the column header. Use the “–” button next to each filter to remove it.
- The group control — allows you to group the data by the value of certain columns. To group by a column, select the column name from the dropdown and click the “+” button, or drag the column header into the control.
- The refresh button forces the grid to fetch a new copy of the data.
- The export button lets you download a CSV file of the data as it appears in the grid. This works the same in plain, group, and pivot outputs.
after grouping by Product
- Click the “+” or “–” button to expand/collapse the rows that belong to that group.
- The group mode toolbar section — “summary” mode shows only the group and the result of the aggregate function. “Detail” mode shows all the rows that go into each group.
after adding Category to the group, and pivoting by Country
- The filter control — here we have added a filter for Country. To add more filters, select the column name from the dropdown and click the “+” button.
- The group control — here we’re grouping first by Category, then by Product. You can drag & drop these fields to reorder them. To add more columns to the grouping, select the column name from the dropdown and click the “+” button. To remove a column, use the “–” button next to the column name.
- The pivot control — we are pivoting by Country in this example. Like the group control, these fields can be reordered; to pivot by additional columns, select them from the dropdown and click the “+” button. To remove a column, use the “–” button next to the column name.
- The aggregate control — in this example, we are calculating the count (number of matching rows) and the sum of the Amount column. Some aggregate functions operate on fields (e.g. sum), whereas others do not (e.g. count). Like the other controls, to add a new aggregate function, select it from the dropdown and click the “+” button. To remove an aggregate function, click the “–” button next to the function name.
- Show/hide total rows and columns.
You can double-click a cell in the group output (summary mode) or pivot output to “drill down” and see all the rows from the data that contribute to the value of that cell. This works by adding a new view called “Drill Down” with filters to show only the contributing rows. The “Drill Down” view will not be saved, so reloading the page will cause the grid to load the previous view.
after drilling down into Germany’s banana orders
Click the view history back arrow in the view toolbar section to go back to the previous view.