Please explain more what you mean by "sum of network", as I thought my first query gave you that exact number. Apparently I do not understand what number you are trying to get.
Perhaps you can say what the number should be, given the data you are providing? Also, please copy/paste from CLI output if possible. The Admin UI screenshots are challenging to read, copy, and edit. On Fri, Aug 19, 2016 at 4:04 AM, 陈繁 <[email protected]> wrote: > Thank you for your reply.Maybe I could not give very clear expression.the > "centos"and"ubuntu" are not hosts,they are docker container on the same > host,so ,i want to get the sum of network > > 在 2016年8月19日星期五 UTC+8上午4:20:16，Sean Beckett写道： >> >> "SELECT SUM(rx_bytes) FROM..." will return the sum across all the series. >> >> "SELECT SUM(rx_bytes) FROM...GROUP BY container_name" will return the SUM >> independently for each container_name >> >> It sounds like you are trying to sum up the total network traffic at each >> interval. Assuming the data is reported in 10 second intervals, a query >> like "SELECT SUM(rx_bytes) FROM...GROUP BY time(10s)" would return that. >> >> There is no way in InfluxDB to do a query like "SELECT rx_bytes + >> rx_bytes..." where one field is from the centos container, and the other is >> from the ubuntu box. You'll have to sum across intervals, not individually >> for every point. >> >> On Thu, Aug 18, 2016 at 1:39 AM, 陈繁 <[email protected]> wrote: >> >>> for example: >>> >>> <https://lh3.googleusercontent.com/-AhsPrY9HfxU/V7Vk2l-k-BI/AAAAAAAAABs/TbTmyeO65qEGtB3xWfq2DUl6Bl9JpHP6wCLcB/s1600/net.png> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> I have two container, so there are two values of rx_bytes.how to get the >>> sum of the different container on the same time？ >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- >>> Remember to include the InfluxDB version number with all issue reports >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "InfluxDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/influxdb. >>> To view this discussion on the web visit https://groups.google.com/d/ms >>> gid/influxdb/7f10f170-393d-44a4-a5ce-3f05c6004956%40googlegroups.com >>> <https://groups.google.com/d/msgid/influxdb/7f10f170-393d-44a4-a5ce-3f05c6004956%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sean Beckett >> Director of Support and Professional Services >> InfluxDB >> > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/78e330f9-9f04-4df5-8622-c370c48a61b7%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/78e330f9-9f04-4df5-8622-c370c48a61b7%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvMEq1OccgVeD-NBDwwK%2BbAOqwFysQGjtrNFjf53uR1RSA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
