Table

The Table visualization displays aggregated data according to the metric.

Metric Aggregations:

  • 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. You should 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.

Enter a string in the Custom Label field to change the default display label.

You can add an aggregation by clicking the button Add Metrics and deleting it by clicking the red cross.

The rows of the data table are called buckets. You can define buckets to split the table into rows.

Buckets aggregation:

  1. Date Histogram

    A date histogram is built from a numeric field and organized by date.

    You need to select the time in "Field" and specify in "Minimum intervals" a minimum time frame in minutes, hourly, daily, weekly, monthly, or yearly.

    You can also specify a custom interval frame by selecting "Custom interval?", and specifying a time unit  in the text field "Fixed interval."

    Custom interval time units are ms for milliseconds, s for seconds, m for minutes, h for hours, d for days.

    Enter a string in the field Custom label to change the display label.

    In addition, you can also add sub-buckets by clicking the button Add sub-buckets

  2. Terms

    A terms aggregation enables you to specify the order ascendent or descendent from the n elements "Size" of a given field to display, ordered by (metric or alphabetical.)

    Enter a string in the field Custom label to change the display label.

    You can add sub-buckets by clicking the button Add sub-buckets

For customizing others Table options, click on the Options tab.