Is there any way to create accurate live Chart to summarize the traffic ( IN and OUT ) from different interfaces and combined into two Data series only to be like below view.
Have you tried using PerfStack?
Yes I'm using PerfStack, But how to create one Chart to summarize the traffic for different interfaces .
With PerfStack you can add interface statistics from multiple disparate interfaces onto the same chart, or within different charts for correlation and comparison.
Yes I did, but I didn't get the one graph reading as suspecting. Below is the one which i get
But in my discussion I need to see only 2 values only for all these interfaces ( Total in traffic and Total out traffic )
Here is what aLTeReGo is talking about only two nodes selected showing total trans + received
Thank You neomatrix1217
If you add another interface from the same or different node it will be shown as third line with separate reading.
I have created SQL Query for this but is not shown the actual traffic ,, so anyone can modify and help to show the actual traffic reading.
SELECT CAST(interfacetraffic.DateTime AS smalldatetime),sum(In_Averagebps),sum(Out_Averagebps),nodeid
from interfacetraffic
where InterfaceID in (8952,8951,8940,8953)
group by CAST(interfacetraffic.DateTime AS smalldatetime),NodeID
order by CAST(interfacetraffic.DateTime AS smalldatetime) DESC
Below is the result but not accurate 100% and when investigate I found the output as below
If you add another interface from the same or different node it will be shown as third line with separate reading.? You can do either you can add it to the line with the two interfaces or create a new line below it.
The visuals were a perfect compliment to the conversation! Many thanks from me.
It is possible to sum values in a time series chart using the Custom Chart resource or Multiple Object Chart.
