How to add new column in the datatable

Elastic Stack Kibana
1

Hi all,
Currently I am working on the sample data that is provided by the kibana.

I want to display a new column in the datatable named "total_Hours". I want to add "Unique Visits (Total)" and "Unique Visits (Last Hour)" and display that column in the datatable.

image
image1766×725 39.6 KB

any help in this regard will be highly appreciated.
Thank You

2

You can't do this in TSVB, but with a Lens datatable and formula it's achievable

1 Like
3

I am new to kibana..can you please elaborate it in detail.

4

Check out this guide: Create visualizations with Lens | Kibana Guide [8.3] | Elastic

Especially the " Use formulas to perform math" section

1 Like
5

I have reached at that point... now i want to add "Average of bytes" and "Top values of hour_of_day", I did not find the way. could you plz guide me regarding this.

image
image1920×926 102 KB

Thank You

6

I think your version of Kibana is too old - once you upgrade to a recent version you should be able to create a new metric dimension, then use a formula like average(bytes) + last_value(hour_of_day)

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.