TSVB Markdown, display the last value for a text field sorted by timestamp e.g. service.state

[sachin-frayne]

Describe the feature: Ability to display the last value of a field that Elasticsearch has received sorted by @timestamp inside the TSVB Markdown widget.

Describe a specific use case for the feature: If I have some services that are sending values for their status through, I may want to build a dashboard that has many of these services displayed and in this case real estate is important. The Markdown editor inside the TSVB seemed like a good case to add some specific custom text as well as some coloring. It can also be shrunk on the dashboard much smaller than the Metric Visual, however, it cannot display the value for a text field, it is currently written to work with aggregations.

It would also be great if we can change the background color depending on the value of the field.

An example of how I want it to be displayed can be seen in the image below:

In theory, this could also be done inside the Markdown visualization, but given it is a timeline question, (what is my latest status), it felt more like TSVB would solve it.

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[ghudgins]

Here's a workaround today -

• use aggregation-based metric vis
• apply a field formatter for the color for the UP / DOWN field

We have plans to offer a more streamlined way of doing this with the lens metric visualization

• use top hits to return the last value sorted on timestamp - [Lens] Allow non-numeric metrics for metric vis #137756
• categorical coloring by name - [Lens] Support categorical coloring by name #101942

[stratoula]

I think this can nicely be done with the new Lens metric, I suggest using this instead of the markdown component