Select and analyze data
Selecting rows or cells of data lets you perform actions such as analyze aggregated metrics, copy the data for use elsewhere, or apply bulk changes more efficiently.
Select rows
When you select rows, the Row count updates in the status bar at the bottom of the grid.
There are several ways to select rows in the grid:
Select a single row: Click its checkbox on the left side of the grid.
Select a range of individual rows: Press and hold the Ctrl key while clicking the row check boxes.
Select multiple consecutive rows: Use one of these methods:
Click and drag your mouse across the rows you want to include.
Select the first row's check box, press and hold the Shift key, click the last row's checkbox, and then release the Shift key.
Select rows in bulk: Click the Row menu and choose from the available options, such as all baseline rows or all rows with a specific workflow status.
Select cells
When you select one or more cells in the grid, the status bar at the bottom displays aggregated information about your selection, including:
Average of the selected cells (for numerical data).
Count of selected cells.
Sum of selected cells (for numerical data).
You can get further metrics using the Analyze selection feature available in the Cell menu.
There are several ways to select cells in the grid.
Select one cell: Click that cell.
Select multiple consecutive cells: Click and drag your mouse across the cells you want to include.
Select all cells in a row or column: Click one of the cells in that row or column, then right-click the cell (or click the Cell menu) to open the Cell selection menu and choose from the available options.
Last updated