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?
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With