Zoomdata Version

Raw Data Tables (RDT)

The raw data table (RDT) chart type is based on at least one metric and one attribute. It contains a table of the raw data from the data source selected for the chart.

This chart type is available to all supported data sources, except Zoomdata's Fusion data source ( ).

Playback mode is not supported for this chart type. For streaming data sources with live mode enabled, the data will not be updated. As a result, the data visualized in the chart is based on the last query that Zoomdata made to the source.

Configuring the Default Settings

You can define the default settings for raw data tables in any data source definition. The settings you supply are used by default when you create a raw data table using the data source definition.

  1. On the Charts tab (for your selected data source), under the Standard tab, select Raw Data Table.

  2. Configure the settings as described in the following table:

    Setting Description
    Columns By default, all data columns are selected. You can display all columns or select only the ones that you want to see. The columns available are all the data columns you can visualize on your chart.
    Rows per Fetch Specify the number of rows that are fetched from the data source at one time. Valid values are integers ranging from 100 to 100000.
  3. Click Save.

Creating a Raw Data Table Chart

To view your data in a raw data table:

  • Create a chart, as described in Creating Dashboards, but select Raw Data Table for the chart type. A raw data table chart is created using the default settings for the selected data source.

You can now modify the raw data table and use it to explore and interact with the data.

Modifying the Raw Data Table

When you first create a raw data table, the default settings for the data source used to create the table are used. Using the Configure Raw Data Table sidebar, you can customize the default fields selected, enlarge or decrease the size of the columns, rearrange the table columns, and sort the data by the column headings.

You can use Keyboard Controls on the Configure Raw Data Table sidebar instead of a mouse.

Customizing Raw Data Table Columns

You can change the columns (fields) that are shown in the raw data table. After you save the dashboard or chart, the column rearrangement is retained when close the dashboard. It is also retained when you share or export the dashboard or chart.

To customize the raw data table fields:

  1. Select Configure on the chart drop-down menu. The Configure Raw Data Table sidebar appears showing a list of columns in the table.

  2. To modify the columns in the raw data table:

    • Click at the bottom of the Configure Raw Data Table sidebar. The sidebar changes to show all the possible fields for the table.
    • Select the columns you want to add and deselect the ones you want to remove. If you want to select all of the columns, click Select All. Use the search bar at the top of the sidebar to search for a field. When you click on the search bar, a filter drop-down menu appears so you can list only fields of a specific type (Number, Attribute, or Time).
    • Click OK.
  3. Click Apply to apply your changes to the raw data table.

  4. Save the dashboard.

Rearranging the Table Columns

You can rearrange the columns in a raw data table. After you save the dashboard or chart, the column rearrangement is retained when close the dashboard. It is also retained when you share or export the dashboard or chart.

To rearrange the table columns in a raw data table:

  1. Select Configure on the chart drop-down menu. The Configure Raw Data Table sidebar appears showing a list of columns in the table.

  2. To move a column, click on its name and then drag it up or down in the list, as appropriate. The first column in the list will appear on the left side of the raw data table.

  3. Click Apply to apply your changes to the raw data table.

  4. Save the dashboard.

Changing the Column Widths

By default, the columns of a raw data table are 100 pixels wide. You cannot change this default.

You can enlarge or decrease the size of these columns while the raw data table is open for viewing. The column widths are retained if you export the table. However, even if you save the dashboard or chart, any customized column widths are lost when you close the table and when you share the table.

To change the column widths:

  • Click and drag the separator between two columns in the appropriate direction.

Sorting Raw Data in the Table

The raw data in the table can be sorted by one or more columns of data. After you save the dashboard or chart, the sort settings are retained when you close it. The sort settings are also retained when you export and share the table.

To sort the raw data rows in a table by the data in a single column:

  • To sort the data in ascending order, click the column heading once.
  • To sort the data in descending order, click the column heading two times.
  • To return the data to its original sort order, click the column heading three times.

Remember to save the dashboard if you want to retain the sort order.

To sort the raw data rows in a table by the data in multiple columns:

  1. Sort the data in ascending or descending order by one column, as described above.

  2. Hold the Shift key down and sort the data in ascending or descending order by a second column. The number 2 appears in the column heading and the data is sorted first by the first column selected and then by the second column selected.

  3. If you hold the Shift key down, you can continue adding additional columns to the sort. The numbers in the column headings will continue to increment. (For example, the number 5 appears in the fifth column heading selected.)

    To interact with a multicolumn sort you must have the Shift key pressed. If you do not have it pressed and you click on a column, the multicolumn sort is canceled and a new sort is performed using the selected column.

    You can change the order (from ascending to descending, for example) of the sort for any column by clicking it once, twice, or three times, as described above. For example, to remove a column heading from the multicolumn sort, click the column heading three times.

    When you change the order of a multicolumn sort, the sequence in which column data is evaluated for the sort is also changed. For example, suppose you initially set up a multicolumn sort that sorts the data in ascending order first by the data in the second column and then by the data in the third column. If you then decide to change the sort of the second column to descending (holding Shift and clicking the column a second time), the table is resorted first in ascending order by the second column and then in descending order by the first column. The column on which you requested the change becomes the last column evaluated for the multicolumn sort.
  4. Save the dashboard.

Was this topic helpful?