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.
Quick analysis menu options
Display information about a particular column in the current table or worksheet.

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.

Quick analysis menu options

Display information about a particular column in the current table or worksheet.

The Quick analysis menu options are accessed by right-clicking a cell in the Grid view and then pointing to Quick analysis of [COLUMN_LABEL].

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

Figure 1. Quick analysis menu in the grid

Basic statistics: Displays the Quick Statistics view which provides summary statistics about the data in a selected column. For more information, see Basic statistics.
Distribution: Displays the Distribution view which lists the frequency, or count of the occurrences, of values in a selected column. For more information, see Distribution.
Histogram: Displays a Histogram view of the selected column. (numerical columns only)