Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Results pane
The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.
Grid view
The Grid view displays data in an infinitely-scrollable, spreadsheet-like interface in the results pane of the Trillion-Row Spreadsheet.
Analyze column data
View statistics about the data values located within a column in the grid.
Basic statistics
The Basic statistics view provides summary statistics about the data in a selected column.

Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
- Analyze
  The Analyze tab displays the object browser and the Analysis Timeline.
- Query
  The Query tab displays the current timeline query as Macro Language XML code. It also provides the ability to undo and redo operations in the timeline.
- View
  Select among the ways to view and interact with the data resulting from your analysis.
- Visualize
  The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
- Develop
  Use the query that represents your analysis as a base for further development.
- Export
  Export the data resulting from your analysis to various destinations.
- Results pane
  The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.
  - View bar
    Choose how data is displayed in the results pane of the Trillion-Row Spreadsheet and Macro Language Workshop.
  - Grid view
    The Grid view displays data in an infinitely-scrollable, spreadsheet-like interface in the results pane of the Trillion-Row Spreadsheet.
    - Column header menu options
      The column header menu provides quick access to commonly used column settings and commands.
    - Editing column metadata information
      Change column information such as the label, format type, and description, directly from the grid.
    - Draw a selection rectangle
      Choose a group of cells by drawing a selection rectangle around a collection of cells in the grid.
    - Grid menu options
      The grid menu provides options for interacting with the data in a table or worksheet directly from within the grid itself.
    - Copy values in the grid
      In the Grid view, you have the option of copying data from a single cell, a group of cells, or all of the cells within a row or column. You can copy up to 100,000 cells of data at a time.
    - Analyze column data
      View statistics about the data values located within a column in the grid.
      - Quick analysis menu options
        Display information about a particular column in the current table or worksheet.
      - Basic statistics
        The Basic statistics view provides summary statistics about the data in a selected column.
      - Distribution
        The Distribution view displays the frequency, or count of the occurrences, of values in a selected column.
    - Finding rows in the results pane
      Locate rows in a table or worksheet without eliminating the rows that do not match your criteria.
    - Scroll directly to a specific row
      You can go directly to a specific row in the grid by right-clicking the vertical scroll bar and entering the row number in the dialog.
    - Scroll directly to a specific column
      You can go directly to a specific column in the grid by right-clicking the horizontal scroll bar and choosing a column in the dialog.
  - Single-row view
    View the cells in a single row of data, arranged vertically.
  - Data Dictionary
    Displays the metadata of columns and tables in the analysis.
  - Visualization
    Displays the chart created from the data analysis.
  - Display a view from the view history
    Display a different view from the view history.
  - Clone the TRS window
    Clone the current view in the Trillion-Row Spreadsheet to a new TRS window.

Basic statistics

The Basic statistics view provides summary statistics about the data in a selected column.

The Basic statistics view in the results pane is accessed by right-clicking a cell in the grid and then selecting Quick analysis of [COLUMN_LABEL] > Basic statistics from the menu.

If a find expression is in effect in the grid, then two columns are shown: one giving the statistics for the entire table, and one giving the statistics for only the highlighted subset of the table. If you change the find expression in the grid, the second column will update automatically.

Note: In this topic, [COLUMN_LABEL] represents the label of the column in which the selected cell is located.

Figure 1. Basic statistics view in the results pane of the TRS and the MLW

The following information is available in the Basic statistics view:

Row count

The total number of values (both N/A and non-N/A) in the selected column.

Valid values

The number of non-N/A values located in the selected column.

N/A values

The number of N/A values located in the selected column.

Mean

The mean of the values in the selected column. (numeric columns only)

If the column contains N/A values, those rows are ignored (i.e., the result is the average of the non-N/A values).
If the column contains only N/A values, the result is N/A.

Std. Deviation

The standard deviation of the values in the selected column. (numeric columns only)

If the column contains N/A values, those rows are ignored (i.e., the result is the standard deviation of the non-N/A values).
If the column contains only N/A values, the result is N/A.

Lowest value

The minimum value located in the selected column.

Median

The median value of the selected column.

Highest value

The maximum value located in the selected column.

Mode

The mode of the values in the selected column.

# modes

The number of times the mode value appears in the selected column.

Unique values

The number of unique values in the selected column.

If the column contains N/A values, those rows are ignored (i.e., the result is the number of unique non-N/A values).
If the column contains only N/A values, the result is 0.