How to add new column in the datatable

malik123 · July 20, 2022, 2:56pm

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.

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

flash1293 · July 21, 2022, 1:30pm

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

malik123 · July 21, 2022, 1:32pm

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

flash1293 · July 21, 2022, 1:34pm

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

Especially the " Use formulas to perform math" section

malik123 · July 21, 2022, 3:00pm

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.

Thank You

flash1293 · July 21, 2022, 4:13pm

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)

system · August 18, 2022, 4:13pm

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