How to display two lines for same field but from different hosts in same visualization?

[pramodchoudhari]

how to display two lines for same field but from different hosts in same visualization using kibana?
i have peakload values from two different hosts and i want them to be displayed in same visualization each line representing peakload values for each host.

suppose there is host1 and host2.
then line1 should represent peakload values for host1 and line2 should represent peakload values for host2.
how should i do it?
Both the lines should be present in same visualization

what should i write in json input so that it will fetch data only from host1
Please Help!!

[jbudz (Jon Budzenski)]

It's close! This will take the max peak load out of all documents. We'll want to scroll down add two aggregations on the x-axis. The first will be date histogram, and the second will be sub bucket using split series with a terms aggregation on the host field.

[pramodchoudhari]

Can you please explain the use of split series?.so that I can use it in future.

[jbudz (Jon Budzenski)]

Sure. We're breaking our metrics down into groups.

First we start with all of our documents in one group. In your screenshot above we're asking for maximum RxPeakKbps, so it's going to give us the maximum overall. When we scroll down and add bucket aggregations, we're splitting these metrics up into more groups.

So we'll say make groups of equal size over our time range, and this'll give us an x value (time range), and y (max RxPeakKbps for this time range). Splitting the series will take each group(time range) and split it further into groups by hostname, giving us two RxPeakKbps to plot.

It'll look something like this: