In kibana(5.1.1) in Data Table visualization how can I Use aggregate function like `(count(*)/sum)` for whole bucket?

Elastic Stack Kibana
1

I want print count(*)/sum(duration) using Data Table visualization for whole bucket how can achieve the same.

2

Hi Akshay,

Can you help me understand what you're trying to get a little better? Below I created a Data Table with 2 metrics, Count of docs and Sum of a field, and then I split rows with a Date Histogram. Is this something like what you want except with the Count/Sum?

image.png2134×1788 258 KB

3

no I want only one column as a output which will contain value of (count divided by sum) here you have two separate columns

4

Is duration a field in your data? Can you show a screenshot of what you have now?