I've got a bunch of network traffic data that looks like this
src | dest | duration (seconds)
----|------|------------------
a | b | 1.37
a | c | 0.44
b | a | 2.32
c | b | 1.73
I need to divide out this data by src and duration per .5 second interval (anything over 3 can be put in a 3+ column), I don't care about dest. So ideally I'd have a table that has src down the left hand side and duration intervals across the top and the counts of transactions per interval in the cells.
The end result I'm looking will look something like this:
src | 0 to .5 | .5 to 1 | 1 to 1.5 | 1.5 to 2 | 2 to 2.5 | 2.5 to 3 | 3+
----|---------|---------|----------|----------|----------|----------|---------
a | 275 | 120 | 32 | 12 | 4 | 3 | 7
b | 315 | 105 | 75 | 28 | 16 | 8 | 12
c | 198 | 113 | 71 | 102 | 173 | 113 | 87
Is this basically a pivot table? Is there a way to do that in Kibana? Any help would be appreciated.