[[aggregation-reference]]
== Create panels with editors

{kib} provides several editors that you can use to create panels of your data. Each editor supports different features and {ref}/search-aggregations.html[{es} aggregations]. To choose the best editor for your data, review the following information.

[float]
[[chart-types]]
=== Supported panel types

[options="header"]
|===

| Panel type | *Lens* | *TSVB* | *Aggregation-based* | *Vega* | *Timelion*

| Table
| &check;
| &check;
| &check;
|
|

| Bar, line, and area
| &check;
| &check;
| &check;
| &check;
| &check;

| Split chart and small multiples
|
| &check;
| &check;
| &check;
|

| Pie and donut
| &check;
|
| &check;
| &check;
|

| Sunburst
| &check;
|
| &check;
| &check;
|

| Treemap
| &check;
|
|
| &check;
|

| Heatmap
| &check;
|
| &check;
| &check;
|

| Gauge and Goal
| &check;
| &check;
| &check;
| &check;
|

| Markdown
|
| &check;
|
|
|

| Metric
| &check;
| &check;
| &check;
| &check;
|

| Tag cloud
| &check;
|
| &check;
| &check;
|

|===

[float]
[[xy-features]]
=== Bar, line, and area chart features

[options="header"]
|===

| Feature | *Lens* | *TSVB* | *Aggregation-based* | *Vega* | *Timelion*

| Dense time series
| Customizable
| &check;
| Customizable
| &check;
| &check;

| Percentage mode
| &check;
| &check;
| &check;
| &check;
|

| Break downs
| 1
| 1
| 3
| &infin;
| 1

| Custom color with break downs
|
| Only for Filters
| &check;
| &check;
|

| Fit missing values
| &check;
|
| &check;
| &check;
| &check;

| Synchronized tooltips
| &check;
| &check;
|
|
|

|===

[float]
[[other-features]]
=== Advanced features

[options="header"]
|===

| Feature | *Lens* | *TSVB* | *Vega* | *Timelion*

| Math
| &check;
| &check;
| &check;
| &check;

| Math across indices
|
|
| &check;
| &check;

| Visualize two indices
| &check;
| &check;
| &check;
| &check;

| Time shift
| &check;
| &check;
| &check;
| &check;

| Custom {es} queries
|
|
| &check;
|

| Normalize by time
| &check;
| &check;
|
|

| Automatically generated suggestions
| &check;
| 
|
|

| Annotations
| &check;
| &check;
|
|

|===

[float]
[[table-features]]
=== Table features

[options="header"]
|===

| Feature | *Lens* | *TSVB* | *Aggregation-based*

| Summary row
| &check;
|
| &check;

| Pivot table
| &check;
|
|

| Calculated column
| Formula
| &check;
| Percent only

| Color by value
| &check;
| &check;
|

|===

[float]
[[custom-functions]]
=== Functions

[options="header"]
|===

| Function | *Lens* | *TSVB*

| Counter rate
| &check;
| &check;

| <<tsvb-function-reference, Filter ratio>>
| Use <<lens-formulas, formula>>
| &check;

| <<tsvb-function-reference, Positive only>>
|
| &check;

| <<tsvb-function-reference, Series agg>>
| Use <<lens-formulas, formula>>
| &check;

| Static value
| &check;
| &check;

|===

[float]
[[metrics-aggregations]]
=== Metrics aggregations

Metric aggregations are calculated from the values in the aggregated documents. The values are extracted from the document fields.

[options="header"]
|===

| Aggregation | *Lens* | *TSVB* | *Aggregation-based* | *Vega*

| Metrics with filters
| &check;
|
|
| &check;

| Average, Sum, Max, Min
| &check;
| &check;
| &check;
| &check;

| Unique count (Cardinality)
| &check;
| &check;
| &check;
| &check;

| Percentiles and Median
| &check;
| &check;
| &check;
| &check;

| Percentiles Rank
| &check;
| &check;
| &check;
| &check;

| Standard deviation
|
| &check;
| &check;
| &check;

| Sum of squares
|
| &check;
|
| &check;

| Top hit (Last value)
| &check;
| &check;
| &check;
| &check;

| Value count 
| &check;
| 
| &check;
| &check;

| Variance
| &check;
| &check;
| 
| &check;

|===

For information about {es} metrics aggregations, refer to {ref}/search-aggregations-metrics.html[Metrics aggregations].

[float]
[[bucket-aggregations]]
=== Bucket aggregations

Bucket aggregations group, or bucket, documents based on the aggregation type. To define the document buckets, bucket aggregations compute and return the number of documents for each bucket.

[options="header"]
|===
| Aggregation | *Lens* | *TSVB* | *Aggregation-based* | *Vega*

| Histogram
| &check;
| 
| &check;
| &check;

| Date histogram
| &check;
| &check;
| &check;
| &check;

| Date range
| Use filters
| &check;
| &check;
| &check;

| Filter
|
| &check;
|
| &check;

| Filters
| &check;
| &check;
| &check;
| &check;

| GeoHash grid
| 
| 
| &check;
| &check;

| IP range
| Use filters
| Use filters
| &check;
| &check;

| Range
| &check;
| Use filters
| &check;
| &check;

| Terms
| &check;
| &check;
| &check;
| &check;

| Significant terms
| &check;
|
| &check;
| &check;

|===

For information about {es} bucket aggregations, refer to {ref}/search-aggregations-bucket.html[Bucket aggregations].

[float]
[[pipeline-aggregations]]
=== Pipeline aggregations

Pipeline aggregations are dependent on the outputs calculated from other aggregations. Parent pipeline aggregations are provided with the output of the parent aggregation, and compute new buckets or aggregations that are added to existing buckets. Sibling pipeline aggregations are provided with the output of a sibling aggregation, and compute new aggregations for the same level as the sibling aggregation.

[options="header"]
|===

| Aggregation | *Lens* | *TSVB* | *Aggregation-based* | *Vega*

| Avg bucket  
| <<lens-formulas, `overall_average` formula>>
| &check;
| &check;
| &check;

| Derivative  
| &check;
| &check;
| &check;
| &check;

| Max bucket   
| <<lens-formulas, `overall_max` formula>>
| &check;
| &check;
| &check;

| Min bucket   
| <<lens-formulas, `overall_min` formula>>
| &check;
| &check;
| &check;

| Sum bucket  
| <<lens-formulas, `overall_sum` formula>>
| &check;
| &check;
| &check;
 
| Moving average  
| &check;
| &check;
| &check;
| &check;

| Cumulative sum 
| &check;
| &check;
| &check;
| &check;

| Bucket script 
| 
| &check;
| &check;
| &check;

| Bucket selector
| 
| 
|
| &check;

| Serial differencing 
| 
| &check;
| &check;
| &check;

|===

For information about {es} pipeline aggregations, refer to {ref}/search-aggregations-pipeline.html[Pipeline aggregations].

include::lens.asciidoc[]
include::tsvb.asciidoc[]
include::vega.asciidoc[]
include::aggregation-based.asciidoc[]
include::timelion.asciidoc[]
