Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Visualize
The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
Chart builder
The chart builder in the Visualize tab allows you to create new charts or modify the appearance of existing charts using a drag-and-drop interface and customizable settings.
Tabulations
You can apply simple tabulations to a chart directly in the chart builder.

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.
  - Chart builder
    The chart builder in the Visualize tab allows you to create new charts or modify the appearance of existing charts using a drag-and-drop interface and customizable settings.
    - Columns panel
      Columns available for plotting in a chart are displayed in the columns panel of the chart builder.
    - Filters panel
      You can perform certain column filter operations in the filters panel of the chart builder.
    - Chart types
      Numerous chart types are supported in the 1010data Insights Platform, including line, scatter, pie, bar, and histogram charts.
    - More Options
      More Options () allows you to create chart labels, axis labels, and customize other elements of the chart.
    - Tabulations
      You can apply simple tabulations to a chart directly in the chart builder.
  - Create a chart
    Create a chart for the current table or worksheet by selecting a chart type and then specifying the data columns to be plotted.
  - Download a chart
    You can download the chart you are currently viewing to your computer as a PNG file.
- 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.

Tabulations

You can apply simple tabulations to a chart directly in the chart builder.

Click Tabulations () for a drop-down list of tabulations you can perform in the chart builder.

Tabulations you can perform in the chart builder include the following:

Counts	The number of rows in each group. The number of rows includes those with N/A values.
Uniques Count	The number of unique values for each group. If a group contains N/A values, those rows are ignored (i.e., the result is the number of unique non-N/A values). If a group contains only N/A values, the result for the group is 0.
Average	The average for each group. (numeric columns only) If a group contains N/A values, those rows are ignored (i.e., the result is the average of the non-N/A values). If a group contains only N/A values, the result for the group is N/A.
Standard Deviation	The standard deviation for each group. (numeric columns only) If a group contains N/A values, those rows are ignored (i.e., the result is the standard deviation of the non-N/A values). If a group contains only N/A values, the result for the group is N/A.
Sum	The sum of each group. (numeric columns only) If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values). If a group contains only N/A values, the result for the group is 0.