Home
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.
Summarizations and tabulations
Some of the basic ways to analyze your data include quick summaries, tabulations, and cross tabulations.
Drilldown analysis
A drilldown analysis provides an interactive way to explore data points and view row-level data in the grid without changing your underlying query.
Drilldown controls in the grid
The drilldown controls in the grid allow you to easily traverse the drilldown hierarchy to look at different aspects of the data.

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.
  - Object browser
    The object browser provides a hierarchy of folders and objects to which you have access. Use the object browser to select the base table or query for your analysis.
  - Analysis Timeline
    The Analysis Timeline displays a visual representation of your data analysis in the Trillion-Row Spreadsheet.
  - 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.
  - Sorting rows
    You may reorder the rows of a table such that the values in a particular column are in ascending or descending order.
  - Arranging columns
    You can display a subset of the columns in a table and specify the order in which they appear.
  - Linking tables and worksheets
    Use linking to combine tables or worksheets into a single, bigger table with columns from both.
  - Computed column
    A computed column is a column that you add to a table, whose values are typically based on one or more existing columns.
  - Summarizations and tabulations
    Some of the basic ways to analyze your data include quick summaries, tabulations, and cross tabulations.
    - Tabulation panel
      The Tabulation panel allows you to perform any of the three basic types of tabulations (quick summaries, tabulations, and cross tabulations) to analyze your data.
    - Perform a quick summary
      A quick summary is a type of tabulation that allows you to easily perform calculations, called summarizations, on one or more columns.
    - Perform a tabulation
      A tabulation summarizes large amounts of data into a small, easy-to-read table. Perform a tabulation to group the values in a column based on the values in another column.
    - Perform a cross tabulation
      A cross tabulation allows you to calculate, or summarize, the values in a column based on the values in two or more other columns and display the result as a matrix.
    - Change the tabulation function summarization
      The tabulation function field defines the calculation, called a summarization, in a quick summary, tabulation, or cross tabulation. Change the summarization to select the type of calculation you want to perform.
    - Use a rollup in a tabulation
      When performing a tabulation with row breaks, you can choose to group like values using the rollup feature.
    - Format the tabulation results
      Define the format of data in columns resulting from any of the three basic types of tabulations (quick summaries, tabulations, and cross tabulations).
    - Drilldown analysis
      A drilldown analysis provides an interactive way to explore data points and view row-level data in the grid without changing your underlying query.
      - Set up a drilldown hierarchy
        Set up a drilldown hierarchy in a tabulation or cross tabulation operation to create a drilldown analysis in the Grid view of the Trillion-Row Spreadsheet.
      - Drilldown controls in the grid
        The drilldown controls in the grid allow you to easily traverse the drilldown hierarchy to look at different aspects of the data.
  - Merging tables and worksheets
    You can merge two or more tables or worksheets to combine their rows together into a single, larger worksheet.
  - Amending values
    Replace the values in a table or worksheet using the amend operation.
  - Running custom code
    You can run custom SQL, Python, R, or K3 code within the TRS Analysis Timeline.
  - Miscellaneous operations
    In addition to the five basic operations, you can choose to use a miscellaneous operation in the Trillion-Row Spreadsheet.
- 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.

Drilldown controls in the grid

The drilldown controls in the grid allow you to easily traverse the drilldown hierarchy to look at different aspects of the data.

The results of a tabulation or cross tabulation containing a drilldown hierarchy display in the Grid view of the Trillion-Row Spreadsheet. Controls in the grid allow you to view more general or more detailed information within a predefined drilldown hierarchy.

Figure 1. Drilldown controls in the Grid view

A. Drilldown hierarchy button: The buttons located at the top of the grid display the remaining tabulation drilldown levels.
B. Drill-up link: In the column header row, column names and labels in orange are drill-up links. The presence of drill-up links indicates that a previous level of detail is available.
Click the contents of the column header row to return, or "drill up," to the previous level of detail in the results. When you drill up into the previous level of detail, the Trillion-Row Spreadsheet removes the appropriate select operation from the timeline and updates the results in the grid.
C. Drilldown link: In a column, values in blue are drilldown links. The presence of drilldown links indicate that an additional level of detail is available for the value.
Click a link to drill down into the next level of detail in the tabulation. When you drill down into another level, the Trillion-Row Spreadsheet adds the appropriate select operation to the timeline, just before the tabulation, and updates the results in the grid.