In Kibana’s visualization, there is a table visualization. We can use this table visualization to show our data, for example:

In the above visualization, we can see that although it shows some data, there are times when we want the data presented to give us an intuitive result. For example, when average Bytes exceed one data point, we want a color to indicate it. This will let us know if there are exceptions and so on. Obviously, normal table visualizations can’t do this. So what do we do? We can use tables in TSVB for this purpose.

In today’s tutorial, we’ll show you how to do this.

 

To prepare data

In today’s presentation, we will use the data that comes with Kibana. Open Kibana:

Click the Add Data button:

Our index KibanA_SAMPLE_datA_logs is now loaded into Elasticsearch.

 

Create Table visualization

We open Kibana Visualization:

Choose TSVB:

Let’s switch to Table and do the above configuration. Then click on Columns:

Select host.keyword under Group by field. So that forms our table, but there are only two columns. We click the plus sign on the right:

This forms the third column of our table. It represents the average number of bytes of data received. Let’s customize the color next:

Let’s click Options and configure it accordingly. This way, when our average is greater than 5000, we will display a red font.

After the above configuration, our table becomes:

Obviously the color has changed. At the same time, the data in the first column can also be clicked to enter the corresponding page.