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.
Analysis Timeline
The Analysis Timeline displays a visual representation of your data analysis in the Trillion-Row Spreadsheet.
Operation controls
The operation controls allow you to make changes to any operation in your data analysis at any point in the timeline.

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.
    - New operation
      Add or insert a new operation to your analysis in the timeline.
    - Operation controls
      The operation controls allow you to make changes to any operation in your data analysis at any point in the timeline.
      - Insert a new operation
        Add an operation to your analysis in the timeline by inserting a new operation.
      - Delete an operation
        Delete an operation from your analysis in the timeline.
      - View the previous operation state
        Move backward through the actions applied to an operation in the Analysis Timeline.
      - View the next operation state
        Move forward through the actions previously applied to an operation in the Analysis Timeline.
      - Edit an operation using Macro Language XML
        Use Macro Language XML code to edit an operation in the Analysis Timeline.
      - Add an operation using Macro Language XML
        Use Macro Language XML code to add an operation to your analysis in the timeline.
    - Submit controls
      The submit controls allow you to submit or cancel changes made to an operation.
    - Expression Editor
      Use the Expression Editor to build valid selection and value expressions in the Trillion-Row Spreadsheet.
    - Filter a list of columns
      Limit the number of column biscuits that are displayed in an operation panel section.
  - 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.
  - 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.

Operation controls

The operation controls allow you to make changes to any operation in your data analysis at any point in the timeline.

You can insert or delete an operation in your analysis, step backward and forward through changes made to an individual operation, and choose the appropriate view for interacting with an operation. Additionally, you can create and manage operation parameters. The operation controls are located at the top left side in each operation panel.

Table 1. Operation control icons
Icon	Name	Description
	Insert operation	Inserts a New operation panel in the timeline directly after the current operation panel. For more information, see New operation. For instructions on inserting an operation, see Insert a new operation.
	Delete operation	Deletes the operation panel from the timeline. For instructions, see Delete an operation.
	Previous operation state	Go back one step in this operation. Note: If the icon is inactive, no previous steps exist. For instructions, see View the previous operation state.
	Next operation state	Go forward one step in this operation. This icon becomes active after clicking the Previous operation state icon to go back one step. Note: If the icon is inactive, no next steps exist. For instructions, see View the next operation state.
	Macro Language view	Displays the Macro Language view for the operation. This view allows you to use Macro Language XML to edit the operation. Note: This icon is displayed only when the operation is in the edit panel view. For instructions, see Edit an operation using Macro Language XML.
	Edit panel view	Displays the edit panel view for the operation. Note: This icon is displayed only when the operation is in the Macro Language view.
	Create block/Edit block	Displays the Block setup view for the operation. This view allows you to create or edit parameters for the operation. Parameters can be used when creating a Quick Query. Queries containing parameters are called Parameterized Quick Queries. For more information, see Quick Queries/PQQs.
	Expand block	Clears the parameters in an operation and displays the operation edit panel view. Note: This icon is displayed in the Parameters view of the operation panel indicating that the operation contains parameters. The Expand block icon is also displayed when creating or editing parameters in the Block setup view.