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.