查看表数据

使用表视图显示表数据。在表视图中，可以重新排序、排序、过滤、格式化和导出数据。

打开表视图

  1. 从平台主页 (www.diligentoneplatform.com) 中，选择结果应用程序以将其打开。

    如果您已经进入 Diligent One，可以使用左侧导航菜单切换到结果应用程序。

  2. Open thecollectionthat contains the table you want to open.
  3. For the table you want to open:
    1. To open the default interpretation, click the table you want to open.
    2. If that table has other interpretations, click the number in theInterpretationscolumn, then click the interpretation you want to open.

重新排列或隐藏列

  1. On the right-hand side of the page, click  Configure.
  2. In the Configure Table View panel, do any of the following and click Apply:
    • To hide all fields, switch off the Enable all fields  toggle. 
    • To hide a single field, switch off the toggle  next to the field name.
    • To display a single field, switch on the toggle  next to the field name.
    • To reorder columns, click and drag the field name up or down to the new position.
      The order in list matches the order in the Table View.

    3. 提示

    您可以在搜索字段中输入关键字或短语，以过滤可用列的列表。

  3. Click  to close the Configure Table View panel.

排序列数据

  1. Do one of the following:
    • Click the header of the column you want to sort.
      Tip

      如果您只想将数据排序，则此方法是最快的。

    • Click the filter icon  to open the View & Add Filters side panel.
      ​If you want to create nested filters in addition to sorting data, you need to use this method.
  2. If you are sorting using a column header, click the Ascending or Descending toggle button. 
    The data in theTable Viewis sorted.
    To remove the sort, click the column header and depending on which type of sort you applied, click the Ascending or Descending toggle button again.
    You can also switch the sort order. If you save the interpretation, the sort order is saved.
  3. If you are sorting using theView & Add Filterspanel, do the following:
    1. Click the arrow in front of Sort by Column.
    2. ClickSelect fieldand select a field from the dropdown list.
    3. Click Normal order A>Z (Ascending) or Reverse order Z-A (Descending). 
      The data in the Table View is sorted. To remove the sort, click Remove sort .
      You can also switch the sort order, or select a different column to sort by.
      You can leave the View & Add Filters panel open, or click  in the title bar to close the panel.
      If you save the interpretation, the sort order is saved.

列数据格式

  1. From the Platform home page (www.diligentoneplatform.com), select the Results app to open it.

    If you are already in Diligent One, you can use the left-hand navigation menu to switch to the Results app.

  2. Navigate to the appropriate table.
  3. Click the header of the column you want to format and in the dialog box selectOptions.
  4. From the list of display format options, select the format you want to apply to the data in the column.

    结果窗口关闭，格式被应用于表。

  5. To save the interpretation, on the right-hand side of the page, do one of the following:
    • ClickSave>Save.
    • ClickSave>Save As.

    当单击另存为时，您可以编辑标题，并可选择输入可视化效果的摘要。

有关格式化列数据的更多信息，请参见数据格式化选项。

应用条件格式到列

  1. Click the header of the column you want to format and in the dialog box selectFormat > Options > Conditional formatting.
  2. To define the condition, clickAdd another conditionand do the following:
    1. From theSelect conditionlist, select a conditional operator.
    2. Enter a value to test against the conditional operator.

      您输入的任何正数不得小于 10-5 或大于 1021。

    3. Select an icon and icon color or selectto disable the icon.
    4. Select a text color or click the toggleto disable text formatting.
    5. Select a background color or click the toggleto disable background formatting.
    6. Optional. To define another condition, clickAdd another conditionand repeat steps a to e.

      Note

      如果对于多个条件，一个字段的值为真，则所定义的第一个条件优先并应用该格式。

  3. To save the interpretation, on the right-hand side of the page, do one of the following:
    • ClickSave>Save.
    • ClickSave>Save As.

    当单击另存为时，您可以编辑标题，并可选择输入可视化效果的摘要。

  4. Optional. To change or remove the formatting applied to a column, click the column header, in the dialog box selectOptions > Conditional formatting, and then update or deletethe condition.

View column-level overview data

  1. For any column in the table, click on the column header.
  2. ClickData Distribution.

结果概览中的数据因该列的数据类型而异。但是，您预计会看到下面的内容：

  • a histogram of the data
  • high, low, and average values
  • standard deviation
  • totals
  • blank values count
  • unique values count
  • number of positives
  • number of negatives

当您应用过滤器到列时，概述数据会更新，以反映列中新的数据子集。

提示

单击列级直方图将直方图转换为新的可视化条形图。

Adjust column widths

  • To adjust a column's width, click and drag the border on the right side of that column's header.
  • To adjust a column's width according to its data, double-click on the border on the right side of that column's header.
  • To adjust the width of multiple columns in one go, perform the following steps:
    1. Shift+ click orCtrl+ click the column headers you want to adjust.
    2. Double-click the border on the right side of one of the selected columns' header.

Note

在调整列宽以及重新调整列宽后，如果想要移除列标题中可能出现的额外空间，请刷新页面。如果列标题包含自由格式的长文本（如问题），则可能会出现此类额外空间。

Wrap column text

如果您的表包含自由格式的长文本（如调查问卷回答），您可以强制该数据环绕以使其更具可读性。环绕文本不会拆分像电子邮件地址或者 URL 这样的长单词。

  1. Click the header of the column you want to wrap.
  2. From the dialog box, switch on theWrap texttoggle.

结果数据会在达到该列边缘时环绕到下一行。如果您调整列宽，该文本将基于新的列宽继续环绕。