在图表中可视化表数据

可视化效果是图表和统计信息，您可以用来展示和传达表数据。

图表类型

选择图表以支持数据维度的数量，或您想要在图表中使用的变量。根据图表类型的不同，您可以显示两个、三个或四个数据维度。

TypeAvailable chartsDescription

条形图

Compares two or three variables using a single value. A bar chart is a graph with rectangular bars and each bar's length is proportional to the value it represents.

Stacked Column Chart

A single second dimension column is divided by third dimension values.

Stacked Bar Chart

A single second dimension bar is divided by third dimension values.

Grouped Column Chart

Third dimension values are displayed as adjacent columns within the second dimension value.

Grouped Bar Chart

Third dimension values are displayed as adjacent bars within the second dimension value.

100% Stacked Column Chart

A single dimension column is divided by the percentage each third dimension value contributes to the total.

100% Stacked Bar Chart

A single dimension bar is divided by the percentage each third dimension value contributes to the total.

折线图

Shows trends or changes over time by displaying a series of data points connected by straight line segments. You can display a single data field as multiple lines based on different categories through Color by field.

Line Chart

Plots changes over short or long periods of time and to assist in predictive data analysis. If small, frequent changes exist in the series, line charts are more effective than bar charts at visualizing the change over time.

组合图

Shows two different sets of data in a single chart. Column and line charts are combined to create a combination chart.

Combination Chart

All the three types of column charts (Stacked Column Chart, Grouped Column Chart, and 100% Stacked Column Chart) can be combined with the line chart. This will help you to do the following in a single chart: 

  • Compare two or more variables that have different magnitudes
  • Show trends or changes over time

面积图

Compares historical trends or changes by showing the proportion of the total that each category represents at any given point in time. Area charts communicate overall trends rather than individual values when comparing multiple data series.

Stacked Area Chart

Shows the proportion of the total that each category represents at any given point in time.

Standard Area Chart

Shows a quantitative progression over time.

100% Stacked Area Chart

Shows how the constituent parts of a whole have changed over time.

The y-axis expands to 100% and each colored area represents one part of the whole, with each part stacked vertically. The height of each colored stack represents the percentage proportion of that category at a given point in time.

饼图

Shows categories as a proportion or a percentage of the whole. Use pie charts to show the composition of categorical data with each segment proportional to the quantity it represents.

Pie Chart

Effective when comparing parts of a whole for a static period. Does not show change over time.

气泡图

Communicates the raw count, frequency, or proportion of a variable. Bubble size reflects quantity, bubble color reflects category, and the x and y axes both display independent values.

Bubble Chart

Effective when you are working with three data series that each contain a set of values.

You can add an optional fourth variable for categorization. The bubble size is effective for emphasizing specific values and comparisons between categories.

热图

Displays individual values in a matrix and represents value as colors. Data points are defined by an x and y axis intersection and a third value that determines the data point's color.

Heat Map

Compares variables across a large number of categories and sorts complex data by color intensity.

摘要表

Groups records on unique values in one or more key fields and then performs a count for the number of matching records.

Summary Table

Drill into the summary by selecting a column and producing a crosstab. Once you define the summary, you can also select numeric fields to subtotal.
树状图表

Displays hierarchical, tree-structured data as a set of nested rectangles.

Treemap

Each group is given a rectangle, which is then tiled with smaller rectangles representing sub-groups. Size and color are used to show separate numeric dimensions of the data.

统计

Shows statistical information in a visually attractive format for one or more fields in a table.

Statistics

Identifies trends or irregularities in a table.

地图图表

Shows geographical data on a chart.

Map chart

Shows values across different geographical locations.

This helps to compare and differentiate trends across different locations.

创建图表

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

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

  2. Navigate to the appropriate table.
  3. 从表视图中，在表的顶部，单击+ 添加可视化效果并选择要创建的图表类型。
  4. 将无标题替换为一个描述性标题。
  5. 在右侧，单击配置 ，在配置可视化效果面板中，单击数据，指定要包含在图表中的数据维度，然后单击应用。

    有关定义您正在使用的图表类型的数据维度的详细信息，请参见图表类型中相应的图表链接。

  6. 于配置可视化效果面板上，单击显示并选择图表的显示选项。

    有关定义您正在使用的图表类型的数据选项的更多信息，请参见图表类型中相应的图表链接。

  7. 要保存您对此解释所做的更改，请单击右上角的保存，然后保存。
  8. 要创建一个新解释：
    1. 单击右上角的保存，然后另存为。
    2. 输入以下信息：
      • 标题为该解释输入一个有意义的名称。
      • 摘要可选。输入该解释的描述。
    3. 单击保存。

提示

如果您要将解释的图片保存为.png或.jpg格式的本地文件，请使用图像捕获工具或屏幕捕获工具创建图像。要了解更多信息，请参考您的操作系统上的屏幕捕捉工具的帮助。

删除图表

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

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

  2. Navigate to the appropriate table.
  3. 从表视图中，在表的顶部，选择该图表的选项卡。
  4. 单击右侧的配置 ，然后在配置可视化效果面板上，单击数据，然后单击删除图表。