Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Develop
Use the query that represents your analysis as a base for further development.

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.
  - Edit a query in the Macro Language Workshop
    View and edit a Trillion-Row Spreadsheet query as XML code in the Macro Language Workshop.
  - Save an analysis as a Quick Query
    Save the operations of an analysis in the Trillion-Row Spreadsheet as a Quick Query.
  - Consolidate timeline
    Consolidate the TRS timeline into as few blocks as possible.
- 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.

Develop

Use the query that represents your analysis as a base for further development.

The Develop tab allows you to send the query to the Macro Language Workshop (MLW) for editing and further development, save the operations from your analysis as a Quick Query, or consolidate your timeline into as few blocks as possible.

Figure 1. Develop tab in the Trillion-Row Spreadsheet

Edit query XML

View and edit your query as XML in the Macro Language Workshop.

When this option is selected, the query from your analysis in the Trillion-Row Spreadsheet appears in a new Macro Language Workshop window and is shown as XML code. From there, you can develop your query further.

For instructions, see Edit a query in the Macro Language Workshop.

Save query

Save the operations from your analysis as a Quick Query.

A saved Quick Query allows you to return to the analysis at a later time or share the analysis with other 1010data Insight Platform users.

For instructions, see Save an analysis as a Quick Query.

Consolidate

Consolidate the timeline into as few blocks as possible.

For instructions, see Consolidate timeline.