Kibana: Divide column data with time range

I have a data table in Kibana with one of the columns representing a metric in terms of hours . I would like to create a new column whose values equal to the hour values divided by the number of hours selected in the time range. How can I do this in Kibana for a Data table ?

Hi @Vishal_Patil ,

welcome to the Kibana community.

What version of the stack are you using?

Within a TSVB Table you can perform a calculation getting access to the current bucket interval with params._interval.

We have deployed 7.11.2. Will it work with that stack ?

Yes, params._interval should be available already in that version under the Math aggregation.

The value contained in that variable is the "width" of each bucket: mind it changes with the current time range selected.

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