Modifying Raw Data Tables

When you first create a raw data table, the default settings specified in the data source configuration are used to create the table.

Using the Configure Raw Data Table sidebar, you can modify the table fields, 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.

See the following topics:

Modifying Raw Data Table Fields

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 clear 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 Raw Data 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 Raw Data Table 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 it is open for viewing. After you save the dashboard, your customized column widths are saved when you close the table and when you share or share it.

To change the column widths of a raw data table:

  • Click and drag the separator between two columns in the appropriate direction. Save the dashboard to save the column widths.

Sorting Data in a Raw DataTable

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.