Selecting rows

Selecting rows is one of the most basic tasks in the 1010data Insights Platform. Use row selection to isolate data that is important to your analysis and create more efficient queries.

Whether you are working with a table that is very small or very large, the first step to answering an analytical question is to narrow down the data you are working with so you see only the pieces of information that apply. While there are many ways to do this, the most basic is a row selection.

When you work with very large data sets like those typically found in the Insights Platform, the order in which you perform operations on the data makes a difference in how fast the system can complete those operations. If you make the largest selection that eliminates the most data first, then the subsequent operations you perform finish faster because the platform does not need to work with as much information. As a best practice, if your data contains columns with date- or time-related information, that is generally the best place to start. However, the largest selection may be something other than date or time information and is based on your data and the analysis you want to perform.

If you perform several row selections in succession, each selection is applied to the previously selected rows. With each selection, the number of rows will decrease (or possibly stay the same); it will never increase. The Analysis Timeline displays every selection applied to the table or worksheet and the number of rows remaining after these selections are listed at the top of the grid. Only those rows that meet your criteria are displayed. Also, if you summarize the data, only the selected rows will be included in the summary.
Note: The selection applies only to your current workspace and does not affect the original table.

There are several ways to perform a row selection in the Trillion-Row Spreadsheet. You can specify the selection criteria using the Simple Comparisons options, enter a selection expression in the Expression Editor, or select rows within the grid itself.