Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visualizing a single string of text in Kibana

In Kibana, I have an index that looks like as follows

  • type (String)
  • value (String)
  • timestamp (Date)

I would like to have a visualization that shows the most recent value field where the type is equal to "battery", for example.

I would like the visualization to be similar to the "Metric" one, but displaying a string of text instead of a number, of course.

Is this possible with Kibana? If not, how can I get a similar result?

like image 505
Forcent Vintier Avatar asked Aug 09 '16 09:08

Forcent Vintier


People also ask

What is TSVB in Kibana?

TSVB is a set of visualization types that you configure and display on dashboards. With TSVB, you can: Combine an infinite number of aggregations to display your data. Annotate time series data with timestamped events from an Elasticsearch index.

What is canvas in Kibana?

Canvas is a data visualization and presentation tool that allows you to pull live data from Elasticsearch, then combine the data with colors, images, text, and your imagination to create dynamic, multi-page, pixel-perfect displays.


1 Answers

You can use a Data Table visualization.

In the search query you would specify type: "Battery"

In the metric section you would specify Max timestamp

In the Split Rows section you would specify Aggregation=Terms, Field=value, OrderBy=metric:Max timestamp, Order=descending, Size=1

You will have a result that is a table with 1 row and 2 columns, one of which being a value and the other a timestamp

If this does not satisfy your needs, you may look into available Kibana plugins that allow new visualizations (see the list of known plugins) or modify one of them to suite your needs.

like image 52
oldbam Avatar answered Nov 07 '22 05:11

oldbam