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


(Akshay Patil) #1

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


(Lee Drengenberg) #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?


(Akshay Patil) #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


(Lee Drengenberg) #4

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


(system) #5

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