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.
Sorting rows
You may reorder the rows of a table such that the values in a particular column are in ascending or descending order.
Use the timeline to sort rows
Sort the table according to one or more columns in ascending or descending order.

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.
    - Use the timeline to sort rows
      Sort the table according to one or more columns in ascending or descending order.
    - Sort rows from the grid column header
      Use the grid column header menu to easily sort the table based on a single column in ascending or descending order.
    - Sort rows within the grid
      Use the right-click menu in the grid to easily sort the table based on a single column 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.

Use the timeline to sort rows

Sort the table according to one or more columns in ascending or descending order.

Change the sort order and direction by dragging columns into the right sorter and selecting a sort direction.

To use the timeline to sort rows:

In the New operation panel, click Sort.
The Trillion-Row Spreadsheet displays the Sort columns panel.
Optionally, to view the column name instead of the column label, select the Show with column name option.
Drag the column on which you want to base the sort from the Columns section to the Order section.
Use the filter () to narrow down the columns in a table with many columns.

The Trillion-Row Spreadsheet displays sorting arrows within the ordered column.

Click one of the following icons:

Option	Description
Sort Up ()	Sorts the rows in the table such that the values in the column are in ascending order.
Sort Down ()	Sorts the rows in the table such that the values in the column are in descending order.

Optionally, to reorder the table based on more than one column, drag additional columns to the Order field and then define the sort order for each column.
Click the Submit operation () icon.
The Trillion-Row Spreadsheet sorts the table based on the column in ascending or descending order.