Data Table
数据表
-
Count 计数
- The count aggregation returns a raw count of the elements in the selected index pattern.
- 索引模式中,元素的原始计数。 Average 平均值
- This aggregation returns the average of a numeric field. Select a field from the drop-down.
- 一个数值字段的平均值,从下拉菜单中选择一个字段。 Sum 综合
- The sum aggregation returns the total sum of a numeric field. Select a field from the drop-down.
- 一个数值字段的总和。 Min 最小值
- The min aggregation returns the minimum value of a numeric field. Select a field from the drop-down.
- 一个数值字段的最小值。 Max 最大值
- The max aggregation returns the maximum value of a numeric field. Select a field from the drop-down.
- 一个数值字段的最大值。 Unique Count 单一计数
- The cardinality aggregation returns the number of unique values in a field. Select a field from the drop-down.
- 去重数据值。 Standard Deviation 标准差
- The extended stats aggregation returns the standard deviation of data in a numeric field. Select a field from the drop-down.
- 一个数值字段的标准差 Percentiles 百分比
- The percentile aggregation divides the values in a numeric field into percentile bands that you specify. Select a field from the drop-down, then specify one or more ranges in the Percentiles fields. Click the X to remove a percentile field. Click + Add to add a percentile field.
- 一个数值字段中,值的百分比分布。使用 X 来移除一个百分比框,使用 + Add 来添加百分比框。 Percentile Rank 百分比排名
- The percentile ranks aggregation returns the percentile rankings for the values in the numeric field you specify. Select a numeric field from the drop-down, then specify one or more percentile rank values in the Values fields. Click the X to remove a values field. Click +Add to add a values field.
- 一个数值字段中,你指定值得百分比排名。
You can add an aggregation by clicking the + Add Aggregation button.
通过+ Add Aggregation按钮增加一个聚集。
The rows of the data table are called buckets. You can define buckets to split the table into rows or to split the table into additional tables.
数据表的每一行称作buckets。你可以定义buckets来切割表格成行,或者切割表格成另一个表格。
Each bucket type supports the following aggregations:
每个bucket类型支持下面的聚合:
-
Date Histogram 日期柱状图
- A date histogram is built from a numeric field and organized by date. You can specify a time frame for the intervals in seconds, minutes, hours, days, weeks, months, or years. You can also specify a custom interval frame by selecting Custom as the interval and specifying a number and a time unit in the text field. Custom interval time units are s for seconds, m for minutes, h for hours, d for days, w for weeks, and y for years. Different units support different levels of precision, down to one second.
- 基于数值字段创建,由时间组织起来。你可以指定时间片的间隔,单位包括秒、分、小时、天、星期、月、年。 Histogram 柱状图
- A standard histogram is built from a numeric field. Specify an integer interval for this field. Select the Show empty buckets checkbox to include empty intervals in the histogram.
- 基于数值字段创建,为这个字段指定一个整数间隔。勾选 Show empty buckets让直方图中包含空的间隔。 Range 类别
- With a range aggregation, you can specify ranges of values for a numeric field. Click Add Range to add a set of range endpoints. Click the red (x) symbol to remove a range.
- 可以为一个数值字段指定一系列区间,点击添加一对区间端点。点击红色 的 (x) 符合移除一个区间。 Date Range 日期类别
- A date range aggregation reports values that are within a range of dates that you specify. You can specify the ranges for the dates using date math expressions. Click Add Range to add a set of range endpoints. Click the red (/) symbol to remove a range.
- 计算你指定的时间区间的值。可以使用data math表达式指定区间,点击Add Range添加新的区间端点,点击红色的 (/) 符号移除区间。 IPv4 Range IPv4类别
- The IPv4 range aggregation enables you to specify ranges of IPv4 addresses. Click Add Range to add a set of range endpoints. Click the red (/) symbol to remove a range.
- 指定IPv4地址的区间,点击 Add Range添加新的区间端点,点击红色的 (/) 符号移除区间。 Terms 条件
- A terms aggregation enables you to specify the top or bottom n elements of a given field to display, ordered by count or a custom metric.
- 允许你指定展示一个字段的首尾几个元素,排序方式可以使计数,或者是其他自定义的metric。 Filters 过滤器
-
You can specify a set of
filters for the data. You can specify a filter as a query string or in JSON format, just as in the Discover search bar. Click
Add Filter to add another filter. Click the
label button to open the label field, where you can type in a name to display on the visualization.
- 你可以为数据指定一组filters,每个filters中可以用query string,也可以用JSON格式,就像在Discover页的搜索栏里一样。点击 Add Filter添加下一个过滤器。 Significant Terms 有意义的条件
- Displays the results of the experimental significant terms aggregation. The value of the Size parameter defines the number of entries this aggregation returns.
- 展示有意义条件的结果。 Size参数的值定义了聚集的返回量。 Geohash 地理哈希
- The geohash aggregation displays points based on the geohash coordinates.
- 显示基于地理坐标的点。
Once you’ve specified a bucket type aggregation, you can define sub-aggregations to refine the visualization. Click + Add Sub Aggregation to define a sub-aggregation, then choose Split Rows or Split Table, then select a sub-aggregation from the list of types.
一旦你定义好了一个bucket类型聚合,可以继续定义子聚合来完善可视化效果。点击+ Add Sub Aggregation来定义子聚合,然后选择Split Rows 或者Split Table,并从类型菜单中选择一个子聚合。
You can use the up or down arrows to the right of the aggregation’s type to change the aggregation’s priority.
你可以使用聚合类型右侧的上下箭头来改变聚合的优先级。
You can click the Advanced link to display more customization options for your metrics or bucket aggregation:
你可以点击Advanced 链接显示更多有关聚合的自定义函数:
-
Exclude Pattern 排除模式
- Specify a pattern in this field to exclude from the results.
- 指定一个从结果集中排除掉的模式。 Exclude Pattern Flags 排除模式标志
- A standard set of Java flags for the exclusion pattern.
- 排除模式的Java flags 标准集 Include Pattern 包含模式
- Specify a pattern in this field to include in the results.
- 指定一个从结果集中要包含的模式 Include Pattern Flags 包含模式标志
- A standard set of Java flags for the inclusion pattern.
- 包含模式的Java flags标准集 JSON Input JSON输入
- A text field where you can add specific JSON-formatted properties to merge with the aggregation definition, as in the following example:
- 一个用来添加JSON格式属性的文本框,内容会合并进聚合的定义中,格式如下例:
{ "script" : "doc['grade'].value * 1.2" }
![Note](https://www.elastic.co/guide/en/kibana/current/images/icons/note.png)
In Elasticsearch releases 1.4.3 and later, this functionality requires you to enable dynamic Groovy scripting.
在Elasticsearch 1.4.3及以后版本,这个函数需要你开启dynamic Groovy scripting。
The availability of these options varies depending on the aggregation you choose.
下面参数是否可用,取决于你选择的聚合函数。
Select the Options tab to change the following aspects of the table:
选择Options 更改表格中如下方面:
-
Per Page 每页
- This field controls the pagination of the table. The default value is ten rows per page.
- 这个输入框控制表格的翻页,默认值是每页10行。
Checkboxes are available to enable and disable the following behaviors:
为了打开或关闭下面的功能,检查窗口是可用的。
-
Show metrics for every bucket/level 为每个bucket/level显示metrics
- Check this box to display the intermediate results for each bucket aggregation.
- 勾选此项,显示每个bucket聚合的中间结果。 Show partial rows 显示部分行
- Check this box to display a row even when there is no result.
- 显示没有数据的行。
![Note](https://www.elastic.co/guide/en/kibana/current/images/icons/note.png)
Enabling these behaviors may have a substantial effect on performance.
开启这些行为可能带来性能上的显著影响
Viewing Detailed Information
查看详细信息
To display the raw data behind the visualization, click the bar at the bottom of the container. Tabs with detailed information about the raw data replace the visualization:
想要展现可视化背后的原始数据,可以点击容器底部的条。用原始数据的详细信息代替可视化结果。
Table. A representation of the underlying data, presented as a paginated data grid. You can sort the items in the table by clicking on the table headers at the top of each column.
Table. 潜在数据的展现,以标页数据格的形式存在。你可以通过点击表头或者圆柱体顶部,对表中的条款进行排序。
Request. The raw request used to query the server, presented in JSON format.
Request. 被用于请求服务器,以JSON形式展现。
Response. The raw response from the server, presented in JSON format.
Response. 来自服务器的响应,以JSON的形式存在。
Statistics. A summary of the statistics related to the request and the response, presented as a data grid. The data grid includes the query duration, the request duration, the total number of records found on the server, and the index pattern used to make the query.
Statistics. 对统计信息的总结,和请求响应相关,以数据格形式展现。数据格包括请求持续、应答持续、服务器中的记录总数和用于请求的索引模式。
To export the raw data behind the visualization as a comma-separated-values (CSV) file, click on either theRaw or Formatted links at the bottom of any of the detailed information tabs. A raw export contains the data as it is stored in Elasticsearch. A formatted export contains the results of any applicable Kibana field formatters.
想要以csv格式输出可视化背后的原始数据,点击任何一个详细信息标签底部的 Raw 或 Formatted 链接。一个原始输出包括存在ES中的数据,一个定制化的输出包括Kibana中应用的结果。
备注:
材料来自elastic官网。
参考整理:
http://kibana.logstash.es/content/kibana/v4/visualize/table.html
地址:
https://www.elastic.co/guide/en/kibana/current/data-table.html