I did a bit of searching and I think this is what I might be after
however I am very new to kibana, to I am unsure if this can be achieved in any other way.
say I have a series of entries like so
type: a start: 3 end: 7
type: a start: 2 end: 5
type: b start: 1 end: 3
type: b start: 8 end: 9
now I want to get the difference (duration) between the min start and the max end per type, yielding something like this
type: a min start: 2 max end: 7 duration: 5
type: b min start: 1 max end: 9 duration: 8
while I can easily create the first 3 columns in a bar chart table view, I am struggling to get the last column to work directly in kibana (exporting the table to excel and doing the visualization there of course is simple, but its a workflow I'd like to avoid if possible)
thanks for any hints, pointers, suggestions!